Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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. 

Pivot.png

Any help is appreciated.

Thanks in advance.

2 Solutions

Accepted Solutions
Highlighted

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(...), '')

View solution in original post

Highlighted
Contributor III
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.

Pivot_1.png

Thanks.

View solution in original post

7 Replies
Highlighted
Contributor III
Contributor III

Re: Hiding the total of a column in pivot table

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

image.png

Highlighted
Contributor III
Contributor III

Re: Hiding the total of a column in pivot table

Thanks for your response Sivakumar.

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

Highlighted

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(...), '')

View solution in original post

Highlighted
Contributor III
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

Highlighted

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

Re: Hiding the total of a column in pivot table

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. 

Pivot_1.png

Highlighted
Contributor III
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.

Pivot_1.png

Thanks.

View solution in original post