Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
select no totals for Individual weighted day cal expression in expression tab.
Thanks for your response Sivakumar.
But I don't see anything as you mentioned in QlikSense Pivot table window.
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
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.
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.