topic Count in QlikView https://community.qlik.com/t5/QlikView/Count/m-p/1012677#M343441 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>I have following data in my QV table</P><P></P><P>PERIOD_DAYS&nbsp; POLICY_NO</P><P>30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1</P><P>31&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P20</P><P>89&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P61</P><P>150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P2</P><P>365&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P4</P><P></P><P>I want to count no of Policies falling into different period ranges and created calculated dimension as follows</P><P></P><P>=if(Aggr(sum(PERIOD_DAYS),POLICY_NO)&lt;=31,dual('ONE_MOMTH',1), </P><P>&nbsp;&nbsp; IF (Aggr(sum(PERIOD_DAYS),POLICY_NO)&lt;=93,dual('THREE_MONTHS',2),</P><P>&nbsp;&nbsp; IF (Aggr(sum(PERIOD_DAYS),POLICY_NO)&lt;=186,dual('SIX_MONTHS',3),</P><P>&nbsp;&nbsp;&nbsp;&nbsp; IF (Aggr(sum(PERIOD_DAYS),POLICY_NO)&lt;=270,dual('NINE_MONTHS',4),</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF (Aggr(sum(PERIOD_DAYS),POLICY_NO)&gt;270,dual('ONE_YEAR',5),</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )))))</P><P>&nbsp; </P><P>This does give me the desired result. Pls help me to correct it </P></BODY></HTML> Sat, 16 Jan 2016 05:17:23 GMT upaliwije 2016-01-16T05:17:23Z Count https://community.qlik.com/t5/QlikView/Count/m-p/1012677#M343441 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>I have following data in my QV table</P><P></P><P>PERIOD_DAYS&nbsp; POLICY_NO</P><P>30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1</P><P>31&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P20</P><P>89&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P61</P><P>150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P2</P><P>365&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P4</P><P></P><P>I want to count no of Policies falling into different period ranges and created calculated dimension as follows</P><P></P><P>=if(Aggr(sum(PERIOD_DAYS),POLICY_NO)&lt;=31,dual('ONE_MOMTH',1), </P><P>&nbsp;&nbsp; IF (Aggr(sum(PERIOD_DAYS),POLICY_NO)&lt;=93,dual('THREE_MONTHS',2),</P><P>&nbsp;&nbsp; IF (Aggr(sum(PERIOD_DAYS),POLICY_NO)&lt;=186,dual('SIX_MONTHS',3),</P><P>&nbsp;&nbsp;&nbsp;&nbsp; IF (Aggr(sum(PERIOD_DAYS),POLICY_NO)&lt;=270,dual('NINE_MONTHS',4),</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF (Aggr(sum(PERIOD_DAYS),POLICY_NO)&gt;270,dual('ONE_YEAR',5),</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )))))</P><P>&nbsp; </P><P>This does give me the desired result. Pls help me to correct it </P></BODY></HTML> Sat, 16 Jan 2016 05:17:23 GMT https://community.qlik.com/t5/QlikView/Count/m-p/1012677#M343441 upaliwije 2016-01-16T05:17:23Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/1012678#M343442 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Your Dimension ,</P><P><STRONG>1st -</STRONG></P><P><STRONG>=if(Aggr(sum(PERIOD_DAYS),POLICY_NO)&lt;=31,dual('ONE_MOMTH',1),</STRONG></P><P><STRONG>&nbsp; IF (Aggr(sum(PERIOD_DAYS),POLICY_NO)&lt;=93,dual('THREE_MONTHS',2),</STRONG></P><P><STRONG>&nbsp; IF (Aggr(sum(PERIOD_DAYS),POLICY_NO)&lt;=186,dual('SIX_MONTHS',3),</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; IF (Aggr(sum(PERIOD_DAYS),POLICY_NO)&lt;=270,dual('NINE_MONTHS',4),</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF (Aggr(sum(PERIOD_DAYS),POLICY_NO)&gt;270,dual('ONE_YEAR',5)</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )))))</STRONG></P><P></P><P><STRONG>2-nd</STRONG></P><P><SPAN style="font-size: 13.3333px;">POLICY_NO</SPAN></P><P></P><P><STRONG>expression:</STRONG></P><P></P><P>Count(POLICY_NO)</P><P></P><P>Hope this helps,</P><P>PFA,</P><P>Hirish</P></BODY></HTML> Sat, 16 Jan 2016 09:06:17 GMT https://community.qlik.com/t5/QlikView/Count/m-p/1012678#M343442 HirisH_V7 2016-01-16T09:06:17Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/1012679#M343443 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P></P> <P>This does give me the desired result. Pls help me to correct it</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>Sorry, I don't understand your request, it seems you get your desired result, why do you want to correct it?</P><P></P><P>As Hirish suggested, using an expression like</P><P></P><P>=Count(POLICY_NO) </P><P></P><P>with your calculated dimension should show the policy distribution over your time buckets (no need for the second dimension, though).</P></BODY></HTML> Sat, 16 Jan 2016 12:13:56 GMT https://community.qlik.com/t5/QlikView/Count/m-p/1012679#M343443 swuehl 2016-01-16T12:13:56Z