Set Analysis YTD

fatihsahin — Fri, 04 Dec 2015 07:20:02 GMT

Hi Community,

i need your help with folowing requirements:

I need a set analysis statement for YTD Calculation.

I have two date fields:

Datefield 1 Value

sep 100

oct 200

nov 300

dec 400

Datefield2

sep

oct

nov

dec

based on the selection in Datefield 2 the ytd should be calculated until the selected month datefield 2.

So if I select NOV in datefield the YTD should run from sep to nov. If is select oct the YTD should run from sep to oct.

But the set analysis statement needs to build with the Datefield1 as this contains also the values.

Basically we need to pass the month of the datefield2 to the set analysis statement.

Thanks for your help.

Regards

Fatih

topic Set Analysis YTD in QlikView