QlikView- Pivot Table- Highlight highest value in different color as per cyclic dimension- Expand/Collapse

Maveer — Mon, 14 Jun 2021 07:42:32 GMT

When user selects first cyclic dimension , highest value gets highlighted in Yellow for each row respective to that.

When user selects second cyclic dimension , highest value gets highlighted in Yellow for each row respective to that.
Where as If we see first 2 rows , the color highlight gone away

When user hides second cyclic dimension , still the color highlight gone away for the first 2 rows

Highlight is done by using Chart- expression - Background Color

if(count(distinct [Sales ID])= Max(total <[Sales Manager],[Sales Guy]>aggr(count(distinct [Sales ID]),[Sales Manager],[Sales Guy],[Year-Month])),yellow(),white())

Note:- I have multiple column in cyclic dimension. 3 cyclic dimension is used

Please help on this .

topic QlikView- Pivot Table- Highlight highest value in different color as per cyclic dimension- Expand/Collapse in QlikView

QlikView- Pivot Table- Highlight highest value in different color as per cyclic dimension- Expand/Collapse