Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
lornafnb
Valued Contributor

Display Frequency in ListBoxes

hi all

In QlikView, one was able to select 'Show Frequency' in the Listboxes - which where extremely useful.

seems that this functionality is not available in sense....Any suggestions/ideas?

I have multiple Dimensions that I need to display in this way on one screen 

 

thanks

 

Labels (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Display Frequency in ListBoxes

Maybe it's an alternatively to use something like this for the listbox:

=aggr(only(Field) & ' - ' & num(count(Field) / count(total Field), '#.##0,00%'), Field)

- Marcus

4 Replies
MVP & Luminary
MVP & Luminary

Re: Display Frequency in ListBoxes

Maybe it's an alternatively to use something like this for the listbox:

=aggr(only(Field) & ' - ' & num(count(Field) / count(total Field), '#.##0,00%'), Field)

- Marcus

anushree1
Valued Contributor

Re: Display Frequency in ListBoxes

Please note that show frequency option is disabled on Key fields and Calculated Fields

lornafnb
Valued Contributor

Re: Display Frequency in ListBoxes

Hi,

Cant see that it works with any field...

lornafnb
Valued Contributor

Re: Display Frequency in ListBoxes

Thank you Marcus