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

how to find last 3 values in Pivot table qlik sense

HI,

 I have a excel total 4 fields. 1 is used to Pivot dimension , 2 fields are used to column field and 1 field ( Sum(sales)) is used for measure value. I got the pivot table with normal white background color.

If i expand 1 column , 7 records will open. How to identify and assign unique colour to the last 3 values in each column. 

Overall color is not required. only last 3 values. How to achieve this. Any idea ?

-Karthick.

 

 

Labels (1)
0 Replies