topic How To Fixed My Date Variable in QlikView

How To Fixed My Date Variable

hamdaniahmad — Wed, 18 Nov 2015 02:21:44 GMT

Hi All,

Need advice from expert,

I’m searching value max date last month value using this:

=AddMonths(max({<DESC= {'STU'}>}Date_Fix),-1)

I put this into variable vMaxLMonth,

Now when is start making my selections, this value, obviously, changes and I like to make it stick with my original calculation prior my selection.

I’m not calculating this in the load script.

Thanks

Gysbert_Wassenaar — Wed, 18 Nov 2015 09:32:10 GMT

If you change it to this then it will ignore all selections:

=AddMonths(max({1<DESC= {'STU'}>}Date_Fix),-1)

hamdaniahmad — Thu, 19 Nov 2015 03:25:05 GMT

Thank you Gysbert.

It is work..!!