Show unique values in chart

[#1]

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

[maternmi]

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

[#3]

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

[maternmi · Accepted solution]

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

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

[#5]

Works like a charm.

Thank you very much for your help

[maternmi]

Hi,

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

Thanks!

BR

Michael