Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Pragna
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
rubenmarin

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

View solution in original post

Pragna
Contributor III
Contributor III
Author

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

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

image.png

Pragna
Contributor III
Contributor III
Author

Thanks for your response Sivakumar.

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

rubenmarin

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

View solution in original post

Pragna
Contributor III
Contributor III
Author

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

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

Pragna
Contributor III
Contributor III
Author

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