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: 
jayaseelan
Creator III
Creator III

Back ground colour in pivot table

Hi Experts,

          I have an query in pivot table background colour. from the below image,  I have dimensions ITEM,PONO and Measure Sum(PRICE), I need to put background colour fro sum(PRICE) measure  with following condition

if(Sum(PRICE)>10,Green(),Red()).

EX1.PNG

I have achieved the above one.


But the my task is, the colour should come only for PONO not for ITEM. My background color formula should not affect the ITEM(Dimension) .


I have highlighted the ITEM name which i don't what to do colour calculation.

it is possible??

EX2.PNG

Kindly help me to do this task.

Thanks,


1 Solution

Accepted Solutions
martinpohl
Partner - Master
Partner - Master

Hi,

so use

if(Dimensionality()=2,

if(sum(PRICE)>10,green(),red())

)

Regards

View solution in original post

1 Reply
martinpohl
Partner - Master
Partner - Master

Hi,

so use

if(Dimensionality()=2,

if(sum(PRICE)>10,green(),red())

)

Regards