Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.