topic select button in QlikView

select button

marikabi — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 28 Apr 2017 19:06:30 GMT

Would you able to share sample?

marikabi — Mon, 01 May 2017 13:15:06 GMT

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 — Mon, 01 May 2017 13:59:16 GMT

Hello,

FYI it's working using this formula :

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

Wish you a nice rest of the day