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

How to display 3 months values based on field selections

Dear Experts,

I need display 3 months values based on Metric_Month field selection. im using below expression to show the numbers, not sure where im doing wrong its not working as expected. Any suggestions please. 

 

Count(DISTINCT{<Month=,Metric_Month={">=$(=Date(Max(Metric_Month)-2,'MMM YYYY'))<=$(=Date(Max(Metric_Month),'MMM YYYY'))"}>}trigger_id)

Metric_Month
Aug 2020
Sep 2020
Oct 2020
Nov 2020

 

Regards,

NR

1 Reply
NavinReddy
Creator II
Creator II
Author

Any Suggestions please