Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show unique values in chart

Hi,

I´m new to Qlikview and are trying to learn the hard way. Now I have a beautiful report that has an error that I am trying to get rid of.

I have a couple of tables linked together with persons and their applications. I would like a chart of their ages, but everyone that has made an application to two or more courses are beeing duplicated in my chart.

Can I make group selection in charts?

My expression in the chart now looks like this

Count (ALDER)

I would like to group that one on distinct PERS_NR

Thank you in advance


Olof

14 Replies
maternmi
Creator II
Creator II

If I understood you right you have ALDER as Dimension and you Count ALDER. Maybe this will helps you
=count({$<ALDER = {'*''}>}  distinct PERS_NR)
BR
Michael
Not applicable
Author

Skärmklipp.PNG

It shows no data and it seems like Qlikview don´t recognize the definition

maternmi
Creator II
Creator II

Hi, please copy and paste again, there was a small mistake

=count({$<ALDER = {'*'}>}  distinct PERS_NR)

Not applicable
Author

Works like a charm.

Thank you very much for your help

maternmi
Creator II
Creator II

Hi,

nice to hear, would you please mark my answer as correct.

Thanks!

BR

Michael