https://community.qlik.com/t5/QlikView/How-to-display-3-months-values-based-on-field-selections/m-p/1769829#M455203 <P>Any Suggestions please&nbsp;</P> Mon, 21 Dec 2020 13:56:20 GMT NavinReddy 2020-12-21T13:56:20Z https://community.qlik.com/t5/QlikView/How-to-display-3-months-values-based-on-field-selections/m-p/1769808#M455202 <P>Dear Experts,</P><P>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.&nbsp;</P><P>&nbsp;</P><P>Count(DISTINCT{&lt;Month=,Metric_Month={"&gt;=$(=Date(Max(Metric_Month)-2,'MMM YYYY'))&lt;=$(=Date(Max(Metric_Month),'MMM YYYY'))"}&gt;}trigger_id)</P><TABLE><TBODY><TR><TD>Metric_Month</TD></TR><TR><TD>Aug 2020</TD></TR><TR><TD>Sep 2020</TD></TR><TR><TD>Oct 2020</TD></TR><TR><TD>Nov 2020</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Regards,</P><P>NR</P> Mon, 21 Dec 2020 13:55:56 GMT https://community.qlik.com/t5/QlikView/How-to-display-3-months-values-based-on-field-selections/m-p/1769808#M455202 NavinReddy 2020-12-21T13:55:56Z https://community.qlik.com/t5/QlikView/How-to-display-3-months-values-based-on-field-selections/m-p/1769829#M455203 <P>Any Suggestions please&nbsp;</P> Mon, 21 Dec 2020 13:56:20 GMT https://community.qlik.com/t5/QlikView/How-to-display-3-months-values-based-on-field-selections/m-p/1769829#M455203 NavinReddy 2020-12-21T13:56:20Z