Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Counting frequency best formula

Hi All,

I did a slider object and put the expression below,

=aggr(count(distinct [Key don]),[Cod pers])

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?

Thank you in advance for your help

Diego

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand
Not applicable
Author

Unfortunately I need it to be influenced by other selections....