Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

I want to add red with max 3 values ​​on each line.

I have field ' Line',' Tank','  Code' 

Used to make a Pivot Table. 

Used Dimensions   Line' and ' Tank'

Used Expressions Count(Code)

Sxbbb_0-1682655265174.png

 

I want to add red with max 3 values ​​on each line.

code used now but the value is incorrect : If(count(Code) = Max(total <Line> Aggr(count(Code), Line, Tank)), LightRed()
,)

I want to add red with max 3 values ​​on each line.

 

 

3 Replies
Kushal_Chawda

@Sxbbb  if I understood correctly, you can but below expression

=if( aggr(rank(count(Code) ,0,4), Line, Tank) <=3, LightRed())

Sxbbb
Creator III
Creator III
Author

I open ToTal and I want to add red with Max ToTal value 

Sxbbb_0-1682993961592.png

 

 

Kushal_Chawda

@Sxbbb  expression which I shared is not working? What is expected output?