Hide empty rows/columns in QlikSense pivot table

[niranjana]

Hi All,

I have already raised question in this thread : How to hide empty columns in QlikSense pivot table... - Page 2 - Qlik Community - 2528258  But, I solutions didnt work.

So I have rephrased the question slightly.

I am in a strange situation. I have 2 dimensions and 2 measures in pivot table. I want to show Sum(visit) for all months i.e. April to Aug 2025. But as for variance, I want to show only for the last month i.e. Aug 2025. 

I have unchecked all the "include zero values " boxes...

I am getting the values correct. Only issue is the months for which I don't want to show profit is not getting hidden. The cells are empty but the months columns still displayed.

Measure 1 : 

if(MonthYear=monthname(Today()) ,

Sum( total <platform,journey_name> { < MonthYear={"$(=monthname(Max(MonthYear)))" }>}visits)
-
Sum(total <platform,journey_name> { <MonthYear={"$(=monthname(Max(MonthYear)-1))"}>}visits)

)

Measure 2 : Sum(visit)

Any help is appreciated..Thanks in advance!!

[robert_mika]

Are you trying to hide the column?

Did you try?

[niranjana]

Hi, Yes I tried hiding columns and putting conditions in show condition as well...but none seems to work....

[marcus_sommer]

It's not possible with the chosen object- and data-structures. If there are results for at least one dimension-value the column is displayed for all.

A quite simple solution would be not to use the periods as dimension else using n expressions - for each wanted visit/variance + period combination an own one.