# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

New Contributor III

## Hiding the total of a column in pivot table

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.

2 Solutions

Accepted Solutions
Highlighted
MVP

## Re: Hiding the total of a column in pivot table

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

## Re: Hiding the total of a column in pivot table

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.

7 Replies
New Contributor III

## Re: Hiding the total of a column in pivot table

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

New Contributor III

## Re: Hiding the total of a column in pivot table

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

Highlighted
MVP

## Re: Hiding the total of a column in pivot table

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

## Re: Hiding the total of a column in pivot table

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

MVP

## Re: Hiding the total of a column in pivot table

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,..."
New Contributor III

## Re: Hiding the total of a column in pivot table

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.

New Contributor III

## Re: Hiding the total of a column in pivot table

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.