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: 
Not applicable

Issue with pivot table

Hi.

I have at pivot table where I first have a overall view end when I expand it I get a more detailed view where I mark values thar are <= 1 as red.

That works fine but I would also like to have red cell when it is collapsed. See attached pictures.

4 Replies
fernando_tonial
Employee
Employee

Hi Tony,

When is collapsed, i don't see values one for mark red?

Best Regards.

Tonial.

Don't Worry, be Qlik.
Not applicable
Author

Hi Fernando, look in attached picture "pivittable1.png".

fernando_tonial
Employee
Employee

Ok.

In attached picture "pivittable2.png", all values are bigger than 1, if you change your rule for <= 30, you see the red mark.

Don't Worry, be Qlik.
Not applicable
Author

It is not that easy.

When the table i expand - if one Station have the value <=1 then the cell should be red

When the table i collapse - if one station for a Area have the value <=1 then the collapsed cell should be red.