topic Re: How to hide empty columns in QlikSense pivot table? in App Development

How to hide empty columns in QlikSense pivot table?

niranjana — Mon, 25 Aug 2025 07:13:35 GMT

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

Re: How to hide empty columns in QlikSense pivot table?

CHRIS_Singa — Mon, 25 Aug 2025 07:40:48 GMT

Unticked the null value in your dimension and data manipulation for the null values.

I might work for you

Re: How to hide empty columns in QlikSense pivot table?

niranjana — Mon, 25 Aug 2025 07:43:05 GMT

Hi , yes unchecked those but still not working....

Re: How to hide empty columns in QlikSense pivot table?

CHRIS_Singa — Mon, 25 Aug 2025 07:49:48 GMT

When I look at the expression. You used IF fucntion.

And last condition is Text(' ') → This means that others columns are filled with space.

Try to remove and unticked everything

Re: How to hide empty columns in QlikSense pivot table?

niranjana — Mon, 25 Aug 2025 09:34:28 GMT

Thanks for reply . Removed text(). and changed measure exp to this :

=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)

)

Removed all conditional shows and unticked all "include null values" boxes. Still getting like this :

Also , there is sum(Sales) which I must show for all months...I think its because of this second measure....

Re: How to hide empty columns in QlikSense pivot table?

Amit_Prajapati — Mon, 25 Aug 2025 09:42:47 GMT

Hi Niranjan,

Try with below expeassion.

alt(

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)

),0)

With the help of alt function it will retrun as 0 and from add-ons just uncheck the include zero values.

Re: How to hide empty columns in QlikSense pivot table?

niranjana — Tue, 26 Aug 2025 03:24:25 GMT

Hi, Tried that as well... The cells show 0 but not getting hidden even after unchecking add-on box...

Re: How to hide empty columns in QlikSense pivot table?

Amit_Prajapati — Tue, 26 Aug 2025 05:20:23 GMT

Hi Niranjan,

You can also create an Master dimenstion as below.

if(MonthYear = monthname(Today()),Month Year) this will return you the month name as Aug 2025 and for other month Year will be - (null) from dimention you can also uncheck the include null values.

Just try once and let me know if it's still not working.

Re: How to hide empty columns in QlikSense pivot table?

niranjana — Tue, 26 Aug 2025 07:38:43 GMT

Hi , Thanks for your help. But it is still not working... I think its because of second measure : "total vis" which I must display for all months.....

Re: How to hide empty columns in QlikSense pivot table?

Amit_Prajapati — Tue, 26 Aug 2025 09:46:44 GMT

Hi,

I also tried the shared one and it's working fine.

if(YearMonth = monthname(Today()),YearMonth)

Before :

After :

Re: How to hide empty columns in QlikSense pivot table?

niranjana — Tue, 26 Aug 2025 10:49:14 GMT

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 🙂