topic Re: Aggr in text box in QlikView https://community.qlik.com/t5/QlikView/Aggr-in-text-box/m-p/561950#M1143434 <HTML><HEAD></HEAD><BODY><P>Hello Tony,</P><P></P><P>Try the following formula:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="_jivemacro_uid_13781804054334041 jive_text_macro jive_macro_code" jivemacro_uid="_13781804054334041"> <P>=count(distinct aggr(IF((((vAvg)*(20/100))+vAvg)&lt;=SUM(Amt),NRID),NRID))</P> </PRE><P></P><P>Regards, Karl</P></BODY></HTML> Tue, 03 Sep 2013 03:53:35 GMT 2013-09-03T03:53:35Z Aggr in text box https://community.qlik.com/t5/QlikView/Aggr-in-text-box/m-p/561949#M1143433 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi All,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Can anyone suggest how to display the count of values displayed in pivot box&nbsp; into a text box.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Attached is the sample Application.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Thanks in advance.<BR /></SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Regards,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Tom</SPAN></P></BODY></HTML> Tue, 03 Sep 2013 03:11:50 GMT https://community.qlik.com/t5/QlikView/Aggr-in-text-box/m-p/561949#M1143433 thomas_skariah 2013-09-03T03:11:50Z Re: Aggr in text box https://community.qlik.com/t5/QlikView/Aggr-in-text-box/m-p/561950#M1143434 <HTML><HEAD></HEAD><BODY><P>Hello Tony,</P><P></P><P>Try the following formula:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="_jivemacro_uid_13781804054334041 jive_text_macro jive_macro_code" jivemacro_uid="_13781804054334041"> <P>=count(distinct aggr(IF((((vAvg)*(20/100))+vAvg)&lt;=SUM(Amt),NRID),NRID))</P> </PRE><P></P><P>Regards, Karl</P></BODY></HTML> Tue, 03 Sep 2013 03:53:35 GMT https://community.qlik.com/t5/QlikView/Aggr-in-text-box/m-p/561950#M1143434 2013-09-03T03:53:35Z Re: Re: Aggr in text box https://community.qlik.com/t5/QlikView/Aggr-in-text-box/m-p/561951#M1143435 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Thanks Karl</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Regards,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Tom</SPAN></P></BODY></HTML> Tue, 03 Sep 2013 03:56:16 GMT https://community.qlik.com/t5/QlikView/Aggr-in-text-box/m-p/561951#M1143435 thomas_skariah 2013-09-03T03:56:16Z