Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

Expression Edits

Hi All,

i want to display 3 months values trend using below expression and variables, i tried with below expression im getting "0" value, Any expression Suggestions. 

variables:

MonthName(Date) as Metric_Month

vMaxDate=monthname(addmonths(max(Date),0))
vMaxDate2=monthname(addmonths(max(Date),-2))

Expression:

=Count(DISTINCT{<Month=,Metric_Month={">=$(=vMaxDate)<=$(=vMaxDate2)"}>}value_id)

 

Thanks & Regards,

NR

Labels (3)
10 Replies
NavinReddy
Creator II
Creator II
Author

Thanks a lot @MK_QSL  and @Taoufiq_Zarra  its working fine