Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
enricohdi2
Contributor
Contributor

freeze selection

Hi,

how can I freeze the selection? we think a time series in month

I can choose Any one month and the selection always starts in January and ends in the selected month

For example, i have a set

january

february

march

april

may

june

july

august

september

october

november

december

- i select july -> then selection starts in january and end in july

- i select january -> then selection starts and ends in january

- i don't select any month -> then selection starts in january and ends in december

1 Solution

Accepted Solutions
MarcoWedel

one example:

QlikCommunity_Thread_247759_Pic1.JPG

QlikCommunity_Thread_247759_Pic2.JPG

table1:

LOAD RecNo() as ID,

    Month(Date#(Ceil(Rand()*12),'M')) as Month,

    Ceil(Rand()*100) as Value

AutoGenerate 100;

tabAsOfMonths:

LOAD *,

    Month(Date#(IterNo(),'M')) as Month

While IterNo() <= AsOfMonth;

LOAD Month(Date#(RecNo(),'M')) as AsOfMonth

AutoGenerate 12;

hope this helps

regards

Marco

View solution in original post

4 Replies
sunny_talwar

If this is for a chart, you can use set analysis. If this needs to be a dashboard wide thing, you can use triggers

Set Analysis for chart

YTQ, QTD, MTD and WTD

Trigger option

Selecting Arbitrary Date Ranges

MarcoWedel

Hi,

maybe helpful:

The As-Of Table

regards

Marco

MarcoWedel

one example:

QlikCommunity_Thread_247759_Pic1.JPG

QlikCommunity_Thread_247759_Pic2.JPG

table1:

LOAD RecNo() as ID,

    Month(Date#(Ceil(Rand()*12),'M')) as Month,

    Ceil(Rand()*100) as Value

AutoGenerate 100;

tabAsOfMonths:

LOAD *,

    Month(Date#(IterNo(),'M')) as Month

While IterNo() <= AsOfMonth;

LOAD Month(Date#(RecNo(),'M')) as AsOfMonth

AutoGenerate 12;

hope this helps

regards

Marco

enricohdi2
Contributor
Contributor
Author

Both answers are correct, but i used the answer of marcowedel

THANK YOU