Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
stavc
New Contributor

dont show column if measure value for max(date) in pivot table is null or 0

hey all,

I have the following pivot table:
2019-01-30_16-43-38.jpgI want that if the value in "area"=0  or is null, in the latest date (in this example in 01/29/2019) then it will not show this block name at all. which means, that in this case, I want to get a pivot table without block "Ranch7", because this block are in the latest date is 0.

if this is not possible, i would like to know if there is any option to color the background of the "area" for the latest date if there is null or 0.

 

Thank you in advance!

1 Reply
MVP & Luminary
MVP & Luminary

Re: dont show column if measure value for max(date) in pivot table is null or 0

It's not possible. Every expression will be shown in a column for every dimension value if for any dimension value the expression has at least one non-zero value. The pivot table does not support text and background colors for expressions yet.


talk is cheap, supply exceeds demand