Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Maveer
Contributor
Contributor

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

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

Vimalesh_0-1623655956704.png

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

Vimalesh_1-1623655998084.png

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

Vimalesh_2-1623656052720.png

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 .

0 Replies