topic Re: Count only one in dimension value in QlikView

Count only one in dimension value

Anonymous — Mon, 11 Jul 2016 16:57:52 GMT

Hello,

I have a chart where I am trying to show number of ID's in each color. But if a ID is in red and Orange then we have to count only once in red.

for example:

ID: 14209 has to counted only in red and for orange it has to show 0.

Below is my sample data.

Thanks for you help

sunny_talwar — Mon, 11 Jul 2016 17:15:31 GMT

May be try this expression:

=If(Count(DISTINCT TOTAL <ID> Color) = 2 and Color = 'Orange', 0, Count(DISTINCT Color))

Anonymous — Mon, 11 Jul 2016 17:38:13 GMT

Sorry I was not clear in my earlier message.

this is my chart:

My Dimension: Color

My Expression: Count(ID)

When the ID has both red and orange, it should only count in red.

so Orange count: 5 and red should be: 5

sunny_talwar — Mon, 11 Jul 2016 18:18:26 GMT

How did you get 5 for Orange here?

Anonymous — Mon, 11 Jul 2016 18:23:53 GMT

sorry typo. orange is 3 and red is 5

sunny_talwar — Mon, 11 Jul 2016 18:47:32 GMT

Try the attached