freeze selection

[enricohdi2]

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

[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 · Accepted solution]

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

[enricohdi2]

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

THANK YOU