Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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

View solution in original post

enricohdi2
Contributor
Contributor

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

THANK YOU