https://community.qlik.com/t5/App-Development/How-to-write-expression-for-below-requirement/m-p/2486145#M101354 <P>Hi Team,</P> <P>&nbsp;</P> <P>Requests are created one by one by the users, each request will have different phases like shown below.</P> <P>&nbsp;</P> <P>RequestNo&nbsp; &nbsp; &nbsp; Phase&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; created_date</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; open&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01-01-2024</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; initial review&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03-02-2024</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; evaluation&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15-04-2024</P> <P>&nbsp;</P> <P>Note:- Phases are in above mentioned order.</P> <P>&nbsp;</P> <P>User need to compare request created i.e Request 1 in&nbsp; phase "initial review"&nbsp; &nbsp; &nbsp; date&nbsp; &nbsp; "03-02-2024" in Feb month and next phase moved to April month.</P> <P>Now user need KPI i.e when they select Feb 2024 &amp; phase="initial review"&nbsp; count=1 and in second KPI when they filter with&nbsp;March 2024 &amp; phase="evaluation" count=0 but when they filter with&nbsp;April 2024 &amp; phase="evaluation" it's need to show count=1.</P> <P>&nbsp;</P> <P>Regards,</P> <P>Sravan.</P> <P>&nbsp;</P> Wed, 09 Oct 2024 09:35:28 GMT Sra1bandi 2024-10-09T09:35:28Z https://community.qlik.com/t5/App-Development/How-to-write-expression-for-below-requirement/m-p/2486145#M101354 <P>Hi Team,</P> <P>&nbsp;</P> <P>Requests are created one by one by the users, each request will have different phases like shown below.</P> <P>&nbsp;</P> <P>RequestNo&nbsp; &nbsp; &nbsp; Phase&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; created_date</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; open&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01-01-2024</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; initial review&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03-02-2024</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; evaluation&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15-04-2024</P> <P>&nbsp;</P> <P>Note:- Phases are in above mentioned order.</P> <P>&nbsp;</P> <P>User need to compare request created i.e Request 1 in&nbsp; phase "initial review"&nbsp; &nbsp; &nbsp; date&nbsp; &nbsp; "03-02-2024" in Feb month and next phase moved to April month.</P> <P>Now user need KPI i.e when they select Feb 2024 &amp; phase="initial review"&nbsp; count=1 and in second KPI when they filter with&nbsp;March 2024 &amp; phase="evaluation" count=0 but when they filter with&nbsp;April 2024 &amp; phase="evaluation" it's need to show count=1.</P> <P>&nbsp;</P> <P>Regards,</P> <P>Sravan.</P> <P>&nbsp;</P> Wed, 09 Oct 2024 09:35:28 GMT https://community.qlik.com/t5/App-Development/How-to-write-expression-for-below-requirement/m-p/2486145#M101354 Sra1bandi 2024-10-09T09:35:28Z https://community.qlik.com/t5/App-Development/How-to-write-expression-for-below-requirement/m-p/2486280#M101374 <P>What it the answer you are getting when you write for both KPIs?</P> <P>COUNT({&lt;Phase = {'<SPAN>initial review</SPAN>'}&gt;}Distinct ReuqestNo)</P> <P>COUNT({&lt;Phase = {'<SPAN>evaluation</SPAN>'}&gt;}Distinct ReuqestNo)</P> Wed, 09 Oct 2024 18:29:10 GMT https://community.qlik.com/t5/App-Development/How-to-write-expression-for-below-requirement/m-p/2486280#M101374 MK_QSL 2024-10-09T18:29:10Z