I am facing Set Analysis issue in Qlikview 11.2 v
The issue is
I have to show the total sum in the set expression for the last month from date
Eg: I have data for some days ( the dates may be from Jan, Feb, Mar), i have to display the data based last month. As of now we got 3 months data in future there may be a chance to increase. I used static value in set expression like below, it worked, but when I place dynamic expression it's not work.
The below one works
The below one not working
Can any one help me to solve this
just create the Month Year field in script using
=monthname(pl_date) as MonthYear
then you get the all expression
Ex: For Feb
ok . Issue was in max() it convert into number and when we use addMonths()
then it again try to convert it into date which cause the issue.
We can simply use addmonths() on datefield
In his case
give better result.