Selection of Last 10, 8, 6 and 4 weeks respectively

[mkb_Qlik]

Hello Geeks,

I have a requirement to include new filter with below values in drop down,

Past 10 weeks

Past 8 weeks

Past 6 weeks

Past 4 weeks.

If i select on any of above value corresponding Past 10 weeks data need to be selected in week filter w.r.to current week filter selected value or No value selected in week filter.

e.g)

1. If week 40 is chosen and if i select Past 10 weeks value, then following weeks needs to be selected

    40,39,38,37,36,35,34,33,32,31

2.) If no week is selected and If i select Past 10 weeks, then past 10 weeks data to be selected basis current week number

Thanks in advance!

[berkarmagan]

Hi, 

I think you can add some flag columns into your calendar table. 4 new flag columns for each your selections.

For example: Flag 10 weeks, and flag your dates if before 10 weeks, put 1 to that cell. Same for the other 3 week columns.

Create an inline table; put your 4 different selections. In the app side, put your inline table as a filter. And in your expression use set expression; if Past 10 weeks selected, in expression put something like {<Flag 10 weeks = {1}>}.

I think it'll work.