topic Re: Show unique values in chart in QlikView

Show unique values in chart

Mon, 09 Feb 2015 18:07:53 GMT

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

Re: Show unique values in chart

Oleg_Troyansky — Mon, 09 Feb 2015 19:17:11 GMT

Hi Olof,

you'll need to explain a bit more - describe the main tables and fields in your data and describe your Chart (all dimensions and expressions). Ideally, post a small sample.

cheers,

Oleg Troyansky

www.masterssummit.com - take your QlikView skills to the next level!

Re: Show unique values in chart

prieper — Mon, 09 Feb 2015 21:56:56 GMT

If you take "PERS_NR" as dimension, it will be the distinct values in a chart.

HTH Peter

Re: Show unique values in chart

Tue, 10 Feb 2015 08:21:24 GMT

Thank you for your reply.

The part I want to make my chart of looks like this. PERS_NR is unique to each person, ALDER is age, ARE_NR is their application number, where the same person can have multiple application which results in duplicates in the chart.

Re: Show unique values in chart

Tue, 10 Feb 2015 08:29:06 GMT

Thank you for the reply.

Now I have ALDER as a dimension and count(ALDER) as expression. If I add PERS_NR as dimension I get a very strange chart. Even if I change ALDER to PERS_NR as expression my chart goes crazy.

Re: Show unique values in chart

maternmi — Tue, 10 Feb 2015 09:12:22 GMT

Hi Olaf,

can you post your chart for better understanding?

Michael

Re: Show unique values in chart

Tue, 10 Feb 2015 09:35:08 GMT

It looks correct until I double check the data and double values appear.

I have also discovered that some people have applied several times so they are listed with different ages. I want to only show the highest age.

Re: Show unique values in chart

maternmi — Tue, 10 Feb 2015 09:48:33 GMT

Hi,

above you writing "but everyone that has made an application to two or more courses are beeing duplicated in my Chart", do you use in your Count formula "distinct"? It will Count each PERS_NR only one tme, doesn't matter how often the Person made an application.

Michael

Re: Show unique values in chart

Tue, 10 Feb 2015 09:58:35 GMT

Thank you for your patience.

I have tried DISTINCT, but it results in the value 1 on every age.

Re: Show unique values in chart

Tue, 10 Feb 2015 10:00:32 GMT

Count ( DISTINCT ALDER)

Re: Show unique values in chart

maternmi — Tue, 10 Feb 2015 10:11:24 GMT

If I understood you right you have ALDER as Dimension and you Count ALDER. Maybe this will helps you

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

Michael

Re: Show unique values in chart

Tue, 10 Feb 2015 10:20:37 GMT

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

Re: Show unique values in chart

maternmi — Tue, 10 Feb 2015 11:54:14 GMT

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

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

Re: Show unique values in chart

Tue, 10 Feb 2015 12:13:56 GMT

Works like a charm.

Thank you very much for your help

Re: Show unique values in chart

maternmi — Tue, 10 Feb 2015 12:16:56 GMT

Hi,

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

Thanks!

Michael