Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Antoine04
Partner - Creator III
Partner - Creator III

How to Hide a column calculted with "before()" in a Pivot Table

Hello all,

In the pivot table bellow, I would like to hide the column in red.

Indeed, there is no DATA because the value Sum(NET) before the year 2021 does not exist.

Antoine04_0-1719328708515.png

Any idea ?

Regards,

Antoine

Labels (3)
2 Replies
ali_hijazi
Partner - Master II
Partner - Master II

for this measure you know there is the "Show Column if"
put the following condition: sum(NET) >0

ali_hijazi_0-1719384493681.png

 

I can walk on water when it freezes
marcus_sommer

It's not possible.