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
Did you mean:
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
MVP
Hi, you can a check for dimensionality() in that expression, like:
If(Dimensionality()>0, Sum(...), '')
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.

Thanks.

7 Replies
Contributor III

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

Contributor III
Author

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

MVP
Hi, you can a check for dimensionality() in that expression, like:
If(Dimensionality()>0, Sum(...), '')
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

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

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.

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.

Thanks.

Community Browser