How to hide empty columns in QlikSense pivot table?

[niranjana]

Hi All,

Above is a QlikSense pivot table. The measure exp is  : 

=if(monthname(Today()) = MonthYear,

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

text('')

)

I am getting the values correct. But those empty columns are not getting hidden. I want to hide all months with empty cells except the maximum/current month.

Tried for more than 3 hrs but couldn't think of any idea. 😛 

Any help is appreciated. Thanks in advance!!

Niranjana

[niranjana]

Thanks but not working......

Hence, I will make it more clear.... in this normal qliksense pivot table : I have two dimenions : field 1 and field 2 . Column is MonthYear..... And there are two measures: sum(sales) [which I must display for all months] and second measure is month-on- month variance which I must display only for last i.e. current month....

I am getting values for MoM variance (for Aug 2025) but other months for this measure are showing empty values....I want to hide these months for which variance must not be caculated : i.e. : April to July I need to hide for this measure.....

Advance thanks for any ideas 🙂