Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
peisenrot
Contributor III
Contributor III

Pivot table have colouring only when one dimension is in first sorting

Hello,

I would like to use a pivot table and define the background colour for the measurements only when the dimension "ResourceName" is shown as first dimension. Is there a filtering name like "firstColumn()"?

Any idea what to do

Labels (2)
2 Replies
peisenrot
Contributor III
Contributor III
Author

hello,

good function but not exact what I am looking for. 

peisenrot_0-1676636950447.png

here I would like to define the colour if Country is given in the line. If I have the line for Product no colouring should be shown. It is not related to the dimensional = 1 or 2 but if the dimensional ='Country' or 'Product'