topic Re: Count number of occurrences in a chart in QlikView

Count number of occurrences in a chart

qv_bazz_10 — Wed, 16 Mar 2016 14:41:36 GMT

Hi everybody,

i'm trying to add a field in a chart to count the number of times a value in a specific field is repeated. This is what i have:

The field i'd like the value to be counted is "PDR" and, as you can see from the image, it's the same for both rows and what i need is a field that, in this case, gives me "2" as a result because the value contained in the "PDR" field is repeated twice.

I tried with the count distinct expression but it always returns "1" as a result, maybe i did something wrong (Siti.COD_DISTRIBUTORE_GAS it the complete name of the field labeled as "PDR" in the chart):

Count(DISTINCT [Siti.COD_DISTRIBUTORE_GAS])

Can anybody help me?

Thanks in advance,

Andrea

Re: Count number of occurrences in a chart

sunny_talwar — Wed, 16 Mar 2016 20:11:05 GMT

What about this:

Count(TOTAL <REMI> [Siti.COD_DISTRIBUTORE_GAS])

Replace REMI with its actually field name.

Re: Count number of occurrences in a chart

qv_bazz_10 — Thu, 17 Mar 2016 07:53:56 GMT

Got it Sunny! I tried your expression and the result was not really the one i was looking for, so i inverted the two fields and it worked perfectly!

Thank you very much Sunny, have a nice day!

Andrea