Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hamdaniahmad
Contributor III
Contributor III

How To Fixed My Date Variable

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

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

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


talk is cheap, supply exceeds demand
hamdaniahmad
Contributor III
Contributor III
Author

Thank you Gysbert.

It is work..!!