topic Re: Hide empty rows/columns in QlikSense pivot table in App Development

Hide empty rows/columns in QlikSense pivot table

niranjana — Thu, 28 Aug 2025 13:05:33 GMT

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!!

Re: Hide empty rows/columns in QlikSense pivot table

robert_mika — Thu, 28 Aug 2025 13:36:34 GMT

Are you trying to hide the column?

Did you try?

Re: Hide empty rows/columns in QlikSense pivot table

niranjana — Thu, 28 Aug 2025 13:40:44 GMT

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

Re: Hide empty rows/columns in QlikSense pivot table

marcus_sommer — Fri, 29 Aug 2025 06:51:06 GMT

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.