topic Re: Count with trick in QlikView https://community.qlik.com/t5/QlikView/Count-with-trick/m-p/458690#M171223 <HTML><HEAD></HEAD><BODY><P>Thanks, Stefan.</P><P>It works for this case.</P><P>Thanks again. </P></BODY></HTML> Tue, 14 May 2013 18:34:03 GMT Anonymous 2013-05-14T18:34:03Z Count with trick https://community.qlik.com/t5/QlikView/Count-with-trick/m-p/458688#M171221 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Please help me to add condition, which calculate count base on product type and the latest date. Or may be different algorithm.</P><P>Some client switched from one type to other. I should calculate the latest product.</P><P>Please see my attached file.</P><P>Thanks,</P></BODY></HTML> Tue, 14 May 2013 16:04:41 GMT https://community.qlik.com/t5/QlikView/Count-with-trick/m-p/458688#M171221 Anonymous 2013-05-14T16:04:41Z Re: Count with trick https://community.qlik.com/t5/QlikView/Count-with-trick/m-p/458689#M171222 <HTML><HEAD></HEAD><BODY><P>Create a chart with dimension</P><P></P><P>=aggr(FirstSortedValue(Product,-[Close Date]), [Account Number])</P><P></P><P>and as expression </P><P></P><P>= count(distinct [Account Number])</P><P></P><P>If you want to group Ent / Pro, I would suggest doing the grouping in the script, creating a new field.</P></BODY></HTML> Tue, 14 May 2013 16:17:14 GMT https://community.qlik.com/t5/QlikView/Count-with-trick/m-p/458689#M171222 swuehl 2013-05-14T16:17:14Z Re: Count with trick https://community.qlik.com/t5/QlikView/Count-with-trick/m-p/458690#M171223 <HTML><HEAD></HEAD><BODY><P>Thanks, Stefan.</P><P>It works for this case.</P><P>Thanks again. </P></BODY></HTML> Tue, 14 May 2013 18:34:03 GMT https://community.qlik.com/t5/QlikView/Count-with-trick/m-p/458690#M171223 Anonymous 2013-05-14T18:34:03Z