topic Re: urgent in QlikView https://community.qlik.com/t5/QlikView/urgent/m-p/492746#M549013 <HTML><HEAD></HEAD><BODY><P>yup just aggregate .</P></BODY></HTML> Fri, 10 Jan 2014 04:56:18 GMT sujeetsingh 2014-01-10T04:56:18Z urgent https://community.qlik.com/t5/QlikView/urgent/m-p/492744#M549011 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have 3 fields named country, state and city.</P><P></P><P>I need to display count of country, count of states inside country and count of cities inside state.</P><P></P><P>Can anybody plz suggest how to display this information in pleasing form on qlikview.</P><P></P><P>Thanks in advance!!!</P></BODY></HTML> Fri, 10 Jan 2014 04:39:38 GMT https://community.qlik.com/t5/QlikView/urgent/m-p/492744#M549011 2014-01-10T04:39:38Z Re: urgent https://community.qlik.com/t5/QlikView/urgent/m-p/492745#M549012 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>To Try the <STRONG>AGGR</STRONG> function.</P></BODY></HTML> Fri, 10 Jan 2014 04:51:29 GMT https://community.qlik.com/t5/QlikView/urgent/m-p/492745#M549012 2014-01-10T04:51:29Z Re: urgent https://community.qlik.com/t5/QlikView/urgent/m-p/492746#M549013 <HTML><HEAD></HEAD><BODY><P>yup just aggregate .</P></BODY></HTML> Fri, 10 Jan 2014 04:56:18 GMT https://community.qlik.com/t5/QlikView/urgent/m-p/492746#M549013 sujeetsingh 2014-01-10T04:56:18Z Re: urgent https://community.qlik.com/t5/QlikView/urgent/m-p/492747#M549014 <HTML><HEAD></HEAD><BODY><P>Can you please explain which objects to use and how to display ? </P></BODY></HTML> Fri, 10 Jan 2014 05:00:00 GMT https://community.qlik.com/t5/QlikView/urgent/m-p/492747#M549014 2014-01-10T05:00:00Z Re: urgent https://community.qlik.com/t5/QlikView/urgent/m-p/492748#M549015 <HTML><HEAD></HEAD><BODY><P>just use count(state) and count(city) where ever required if it is independent of selection use count({1}state) </P></BODY></HTML> Fri, 10 Jan 2014 05:24:46 GMT https://community.qlik.com/t5/QlikView/urgent/m-p/492748#M549015 2014-01-10T05:24:46Z