select button

[marikabi]

Hello,

I am tying to create a button in order to select from the field "Week_Year" the last 4 weeks.

Note, that I can't use formulas like Week(Today) etc., because the data are not loaded at fixed frequency..

The dimension Week_Year is structured in this way:

WW_YY   (eg, week 17 of 2016 --> 17_16)

There is another dimension, called W_order, that assigns to each week (starting from week 1_16 = 1) an increasing value.

WHat I need to have is a button that allows to easily filter the data for the last 4 week (for those weeks where I already have the data loaded).

Any iea?

Many thanks in adavnce

[Anil_Babu_Samineni]

Would you able to share sample?

[marikabi]

Hello,

what I'm trying to do is really simple:

Let's use april 2017 as a sample.

We have the date for the weeks 14, 15, 16, 17.

On qlik, I will have the dimension Week_Year structured in this way:

14_17 15_17 16_17 17_17..

The button has to select the data for these weeks pushing on it..

They are the last 4 weeks for whom I have uploaded the data..

[marikabi]

Hello,

FYI it's working using this formula :

= '>=' & Max( W_order - 4 ) 

Wish you a nice rest of the day