Discussion board where members can get started with QlikView.
I'm trying to use this equations in my chart, for the background part of my expression:
I want the cells for 'Source' to have a red background when the count(Source) is less than 2.
The above equation won't work, everything is highlighted red.
how do I fix this?
Go to Solution.
=IF(Count(<Total Destination1> Distinct Source)>2, RGB(255,66,66), Count(<Total Destination1> Distinct Source))
Count(Source) and Count(DISTINCT Source) are two different things... Do you want just the count for each Destination1 or the DISTINCT count?
and I don't think you need to use Aggregate function if you only have Destination1 as your dimension:
=If(Count(Source) < 2, Red(), Green()) //use DISTINCT if required