Hiding the total of a column in pivot table

[Pragna]

Hi Everyone,

I have an issue of hiding the total of a column in the pivot table. 

As highlighted below, Need to hide 261.9 value in the Pivot table. 

Any help is appreciated.

Thanks in advance.

[sivakumar1994]

select no totals for Individual weighted day cal expression in expression tab.

[Pragna]

Thanks for your response Sivakumar.

But I don't see anything as you mentioned in QlikSense Pivot table window.

[rubenmarin · Accepted solution]

Hi, you can a check for dimensionality() in that expression, like:
If(Dimensionality()>0, Sum(...), '')

[Pragna]

Hi Ruben,

I have 2 dimensions and 2 expressions in the pivot table.

I tried using this formula but getting Null values for the entire column. Please let me know if my expression is incorrect.

Individual weighted day =

If(dimensionality()=2,'',

(Sum(Aggr(
Sum([Days Coverge])
*
(Sum({<Calender_Year=,Calender_Year_Week=,Calender_Week_Start_Num={">=$(vMinSelectedDate)<=$(vMinSelectedDatePlus7Weeks)"}>}[Total Dmd])
/
Sum(total<[Aggregate Master Customer ID]>{<Calender_Year=,Calender_Year_Week=,Calender_Week_Start_Num={">=$(vMinSelectedDate)<=$(vMinSelectedDatePlus7Weeks)"}>}[Total Dmd]))
,[Aggregate Master Customer ID],InvSrs_MaterialID))))

Thanks

[rubenmarin]

Try to set a metric just with "Dimensionality()", adapt the "If(dimensionality()=2,''," to the values you will see, total rows has to lower values so maybe you need "If(dimensionality()<2,..."

[Pragna]

Thanks for your quick response.

I tried using the below formula as you suggested.

Individual weighted day =If(dimensionality()<2,
(Sum(Aggr(
Sum([Days Coverge])
*
(Sum({<Calender_Year=,Calender_Year_Week=,Calender_Week_Start_Num={">=$(vMinSelectedDate)<=$(vMinSelectedDatePlus7Weeks)"}>}[Total Dmd])
/
Sum(total<[Aggregate Master Customer ID]>{<Calender_Year=,Calender_Year_Week=,Calender_Week_Start_Num={">=$(vMinSelectedDate)<=$(vMinSelectedDatePlus7Weeks)"}>}[Total Dmd]))
,[Aggregate Master Customer ID],InvSrs_MaterialID))),
'')

Below is how the pivot table is displaying. 

[Pragna · Accepted solution]

Hi Ruben,

This formula actually worked. Thank you so much.

If(Dimensionality()=0,
'',
(Sum(Aggr(
Sum([Days Coverge])
*
(Sum({<Calender_Year=,Calender_Year_Week=,Calender_Week_Start_Num={">=$(vMinSelectedDate)<=$(vMinSelectedDatePlus7Weeks)"}>}[Total Dmd])
/
Sum(total<[Aggregate Master Customer ID]>{<Calender_Year=,Calender_Year_Week=,Calender_Week_Start_Num={">=$(vMinSelectedDate)<=$(vMinSelectedDatePlus7Weeks)"}>}[Total Dmd]))
,[Aggregate Master Customer ID],InvSrs_MaterialID)))
)

Pivot table is displaying correctly.

Thanks.