Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Tadyy
Contributor II
Contributor II

Pivot table separate row color

Hello

I have a pivot table with 2 dimensions - 2 values in first dimension and 3 values in second. That gives me a table with 6 rows. The problem I have to compare (color) each row result with a different target value.

I'm coming from excel, where this was easily done just by referencing a cell value, but being new to qlik, i'm having trouble even figuring out if what i want is even possible.

 

 

Labels (1)
4 Replies
abhijitnalekar
Specialist II
Specialist II

Hi @Tadyy ,

Please try the below-highlighted property of the column where yo can set the expression for the color.

abhijitnalekar_0-1648797555574.png

 

 

Regards,
Abhijit
keep Qliking...
Tadyy
Contributor II
Contributor II
Author

I've tried that, my issue is what to write inside there. Because it's a pivot table, but I need every row to be colored based on external value that should be specific to that row - I don't know how to identify each specific row with qlik syntax (if that makes sense)

Added what my excel example looks like below

Screenshot_2.png

abhijitnalekar
Specialist II
Specialist II

Hi @Tadyy ,

 

You can do the same by writing the expression base on your logic.

Regards,
Abhijit
keep Qliking...
Tadyy
Contributor II
Contributor II
Author

well in excel the calculation is part of the pivot, the targets are normal cells that I reference to for the formatting. But how to tell qlik to look basically for 1-a to look at 4,5 and 1-b to look at 5,0...