Count cells in chart depending on color

ahmedhali — Wed, 25 Nov 2020 16:16:04 GMT

I have a question regarding charts. Is it possible to count chart cells depending on whether they are green or red? For example in the chart below the expression would say there is 2 green on the second row and 3 on the first.

Thx in advance!

Re: Count cells in chart depending on color

ahmedhali — Wed, 05 Oct 2016 12:01:49 GMT

I solved this by taking the expression that makes the coloring and changed the true and false statement from color to 1 and 0. Then I proceeded to add them together. For example

if(sum(column(1)+column(2))>=column(3),1,0)

if(sum(column(4)+column(5))>=column(6),1,0)

Maybe not the best solution but it got the job done. Hope this will be relevant for anybody

/Ahmed

topic Re: Count cells in chart depending on color in QlikView

Count cells in chart depending on color

Re: Count cells in chart depending on color