topic Re: Counting colors in QlikView

Counting colors

Tue, 17 Sep 2013 06:13:49 GMT

I have a graph like this:

How can i count how many bars are Blue, Red and Green?

My expression is like this for Background color

if (ABC='A',LIGHTRED() ,if (ABC='B',LIGHTBLUE(),if (ABC='C',LIGHTGREEN())))

Best regards

/Mats

Message was edited by: matshawk

Re: Counting colors

tresB — Tue, 17 Sep 2013 06:27:29 GMT

That depends on how your expression decides on color. Please share a sample app.

Re: Counting colors

AbhijitBansode — Tue, 17 Sep 2013 06:59:27 GMT

It all depends on your expression.

But if you have limited number of values in your dimension then something like below would help:

count({<ABC= {'A'}>}ABC) -- # of LightRed bars

count({<ABC= {'B'}>}ABC) -- # of LightBlue bars

Re: Counting colors

tresB — Tue, 17 Sep 2013 07:02:03 GMT

Again, dimension members are needed. Anyway, try like this: take a straight table with similar dimension member and expression as : If( ABC='A', 'RED :'&Count(ABC), IF(ABC='B' , 'Blue :'&Count(ABC), If(ABC='C', 'Green :'&Count(ABC))).

Though i am not sure it would work. Best way could have been- sharing sample app. If you are worried about the data, you can always scramble it upload. See how to prepare for upload .

Re: Counting colors

Tue, 17 Sep 2013 10:03:55 GMT

I have come some way by doing like this:

My dimension is Machine_Beläggning of which are divided in some 'A', some 'B' and some 'C' machines

If i have an expression like this: if (ABC='A',1, count({<ABC= {'A'}>}ABC) ), i get one bar for each machine that is an 'A' machine. So far so good... The thing is that i don't want bars, just a number that are the sum of the 'A' machines, in this case 7.

Best regards

/Mats

Re: Counting colors

er_mohit — Tue, 17 Sep 2013 10:11:15 GMT

if you want to count it then take three text object with equal sign write your condition

like this

=count(if (ABC='A',ABC)) //for 1st one text object

count(if (ABC='B',ABC)) //for LIGHTBLUE() for 2nd text obj

count(if (ABC='C',ABC)) // for LIGHTGREEN() (3rd text obj)

hope it helps

Re: Counting colors

tresB — Tue, 17 Sep 2013 10:12:38 GMT

May be like this? take ABC as a dimension in a straight table and use expression: Count(ABC)

Re: Counting colors

stigchel — Tue, 17 Sep 2013 10:19:01 GMT

Without a dimension you would need an aggagrate:

Aggr(Count(if(ABC='A',ABC)),Machine_Beläggning)

Re: Counting colors

Tue, 17 Sep 2013 10:45:56 GMT

I only want to count the ’A’s, ’B’s or ‘C’s that have values on them.

Does this make sense?

7 ‘A’s, 3 ‘B’s and 6 ‘C’s

/Mats

Re: Counting colors

tresB — Tue, 17 Sep 2013 10:56:31 GMT

Then try the expression something like:

Count(If(not isnull(YourValueField) and YourValueField<>0, ABC)

Re: Counting colors

Thu, 19 Sep 2013 11:05:04 GMT

If i do like this i get the result like the table in the picture

If someone please have the solution i would be very greatful!

/Mats