Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

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

Hi,

maybe helpful:

The As-Of Table

regards

Marco

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

Contributor
Contributor

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

THANK YOU