Qlik Community

New to Qlik Sense

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

Announcements
QlikWorld online is next week! REGISTER NOW
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
Partner

Hi,

so use

if(Dimensionality()=2,

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

)

Regards

View solution in original post

1 Reply
martinpohl
Partner
Partner

Hi,

so use

if(Dimensionality()=2,

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

)

Regards