topic Counting frequency best formula in QlikView https://community.qlik.com/t5/QlikView/Counting-frequency-best-formula/m-p/1110293#M462699 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I did a slider object and put the expression below, </P><P></P><P>=aggr(count(distinct [Key don]),[Cod pers])</P><P></P><P>It works but as the database is too big the slider crash when I do a selection. Is there a way to do the same expression in a smarter way so the slider will no break down?</P><P></P><P>Thank you in advance for your help</P><P></P><P>Diego</P></BODY></HTML> Tue, 30 Aug 2016 09:14:40 GMT 2016-08-30T09:14:40Z Counting frequency best formula https://community.qlik.com/t5/QlikView/Counting-frequency-best-formula/m-p/1110293#M462699 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I did a slider object and put the expression below, </P><P></P><P>=aggr(count(distinct [Key don]),[Cod pers])</P><P></P><P>It works but as the database is too big the slider crash when I do a selection. Is there a way to do the same expression in a smarter way so the slider will no break down?</P><P></P><P>Thank you in advance for your help</P><P></P><P>Diego</P></BODY></HTML> Tue, 30 Aug 2016 09:14:40 GMT https://community.qlik.com/t5/QlikView/Counting-frequency-best-formula/m-p/1110293#M462699 2016-08-30T09:14:40Z Re: Counting frequency best formula https://community.qlik.com/t5/QlikView/Counting-frequency-best-formula/m-p/1110294#M462700 <HTML><HEAD></HEAD><BODY><P>You could pre-calculate the count values in the script. But then the counts won't be influenced by other selections. Perhaps a listbox with [Cod pers] as field and count(distinct [Key don]) as expression also works.</P></BODY></HTML> Tue, 30 Aug 2016 11:56:07 GMT https://community.qlik.com/t5/QlikView/Counting-frequency-best-formula/m-p/1110294#M462700 Gysbert_Wassenaar 2016-08-30T11:56:07Z Re: Counting frequency best formula https://community.qlik.com/t5/QlikView/Counting-frequency-best-formula/m-p/1110295#M462701 <HTML><HEAD></HEAD><BODY><P>Unfortunately I need it to be influenced by other selections....</P></BODY></HTML> Tue, 30 Aug 2016 12:36:24 GMT https://community.qlik.com/t5/QlikView/Counting-frequency-best-formula/m-p/1110295#M462701 2016-08-30T12:36:24Z