topic freeze selection in QlikView

freeze selection

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

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

Re: freeze selection

sunny_talwar — Fri, 27 Jan 2017 11:06:18 GMT

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

Re: freeze selection

MarcoWedel — Fri, 27 Jan 2017 23:37:38 GMT

Hi,

maybe helpful:

The As-Of Table

regards

Marco

Re: freeze selection

MarcoWedel — Fri, 27 Jan 2017 23:54:51 GMT

one example:

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

Re: freeze selection

enricohdi2 — Thu, 02 Feb 2017 08:17:26 GMT

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

THANK YOU