Hide selected columns

DeveloperCYT
DeveloperCYT
in User Experience

Hi, 

I have a module and it is filtered on a rolling 3 week pattern
In the first week i would like to show some most of the columns but then in week 2 and 3 i would like to hide some columns (yellow)
I can use hide selected or show selected, but when the filter rolls to next week the selections will be in the wrong weeks.

DeveloperCYT_0-1666942108474.png

Is there a way to maintain the look below without having to hide / show each week?

DeveloperCYT_1-1666942196837.png

Thanks

 

 



Tagged:

Answers

  • StevenBeerthuizen
    StevenBeerthuizen

    You can create a boolean in a system module with your weeks and filter the view on that boolean.
    KR,
    Steven

     

    edit: you need a module with a line item subset and your weeks (as far as i can guess from your screenshot)

  • DeveloperCYT
    DeveloperCYT

    I already filter on the weeks in a system module, but that doesn't let me hide or show different line items in a week

    DeveloperCYT_0-1666942798661.png

     

    this is what happens when the week rolls if i use hide / show selected

    DeveloperCYT_1-1666942945794.png

     

     

  • StevenBeerthuizen
    StevenBeerthuizen
    I have edited my previous reply....please have a look.
    Kr,
    Steven
  • DeveloperCYT
    DeveloperCYT

    Sorry, i am being a bit slow today

    Can you explain clearly, as i can't follow this

    Many thanks

  • StevenBeerthuizen
    StevenBeerthuizen

    You create a line item subset from the module that you have in the screenshot. Use this line item subset in your filter module and use a boolean line item in that filter module to select items of that line item subset and weeks combined (if the first week then show more line items, else show less). Then you filter the module of the screenshot with that boolean (from the filter module).

    Kr,

    Steven

  • DeveloperCYT
    DeveloperCYT

    Ok i have that working
    But you have to change those ticks each week, so still a manual process.
    and LISS don't work with text line items, and 4 of mine are text

     

    Thanks for the idea though

     

  • ManjunathKN
    ManjunathKN

    Hi @DeveloperCYT 

     

    I think you can get this done by @StevenBeerthuizen  first idea only because you have text based items to filter, otherwise LISS would be easy solution here. 

     

    as far the selection is concerned you should not do manual based selection but formula based, comparing between current week and next 2 weeks.

     

    Thanks,
    Manjunath

  • DeveloperCYT
    DeveloperCYT

    Hi,

    Yes that makes sense for the filter
    but as I must have the text line items I cannot use this solution.

     

    Thanks

     

  • ManjunathKN
    ManjunathKN

    okay!

     

    I dont think you can achieve filtering in given scenario. Can you create a Fake time of week(3 weeks) and can you bring your line items by formula. so that your structure is fixed and you can display the current week.

     

     

     

     

  • DeveloperCYT
    DeveloperCYT

    Hi,
    How would I formulate the next 2 weeks, as you can't formula by LISS item?

    DeveloperCYT_0-1667023234677.png

     

  • ManjunathKN
    ManjunathKN

    @DeveloperCYT 

     

    Create five more line item,

     

    LI 1 - Remove time from module calendar, select manually order and stock,

    LI 2 -Remove time from module calendar, select other four line item,

    LI 3 - write a formula to get values for only next week using LI 1(ex: if Next 2 weeks then LI 1 else false)

    LI 4- write a formula to get values for only next week using LI 2(similar to above)

    LI 5 - Availability filter or LI 3 or LI 4 - Summary as formula.

     

    Thanks,
    Manjunath

     

  • ManjunathKN
    ManjunathKN

    LI 5 is your final filter.

  • M.Kierepka
    M.Kierepka

    Hi @DeveloperCYT,

    Have you considered spliting it into two grids, and if needed, utilizing synchronized scrolling? Narrow grid on the left with text (maybe new module without time dimension), bigger on the right with numbers (you can hide/remove line items with text completely). You might want to watch this: https://community.anaplan.com/t5/Feature-Updates/Synchronize-Scroll/ba-p/137502
    Here is Anapedia page about how to do it: https://help.anaplan.com/2c4d94c7-e56c-429c-b73d-aff0f52a4b99-Synchronize-scrolling-for-grids-on-a-page

     

  • DeveloperCYT
    DeveloperCYT
    Thanks, tweaked it slightly but all working now.

Categories