Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am transitioning a dashboard from QlikView to QlikSense and a set analysis expression that works perfectly fine in QlikView is not working at all in QlikSense.
Here is the expression from QlikView:
Count({<MonthYear ={">=$(=date(addmonths(date#('$(vYearMonth)','MMM-YYYY'),-11),'MMM-YYYY')) <=$(=date#('$(vYearMonth)','MMM-YYYY'))"}, Year=,Month=>} DISTINCT(ows_ID))
Can someone please help in getting this to work in QlikSense?
Data models between QlikView and QlikSense are exactly the same and the variable is declaring the correct value so I am stumped!!
Thanks in advance
Carl
Hi,
Make sure you have '=' sign in variable definition.
=date(max(MonthYear),'MMM-YYYY')
Regards,
Kaushik Solanki
How is your variable vYearMonth defined?
Also Your MonthYear field looks to be text values
Defined as follows through the Variable Interface screen:
date(max(MonthYear),'MMM-YYYY')
MonthYear is from the Master Calendar.
Count({<MonthYear ={">=$(=date(addmonths(date#("$(vYearMonth)",'MMM-YYYY'),-11),'MMM-YYYY')) <=$(=date#("$(vYearMonth)",'MMM-YYYY'))"}, Year=,Month=>} DISTINCT(ows_ID))
Just Try This code . I have just changed the single quotes into "Double quotes". This should probably work. Also make sure the vYearMonth variable is defined.
No luck unfortunately. Thanks for replying.
Hi,
Make sure you have '=' sign in variable definition.
=date(max(MonthYear),'MMM-YYYY')
Regards,
Kaushik Solanki
Thank you!!!!
Pleasure.
Also keep in mind that whenever you go to variable definition and close that with or without doing changes, the '=' sign gets removed automatically, so make sure in such cases you check if the sign is there or not.
Regards,
Kaushik Solanki