topic Re: subtotal in a Pivot table in QlikView

subtotal in a Pivot table

mario-sarkis — Wed, 05 Aug 2015 10:45:34 GMT

Hey ,

any Idea if i dont want to show the subtotal in a pivot table how can i do it ?

Re: subtotal in a Pivot table

sunny_talwar — Wed, 05 Aug 2015 10:48:24 GMT

Uncheck 'Show Partial Sum' for all your dimension on the presentation tab:

Re: subtotal in a Pivot table

PrashantSangle — Wed, 05 Aug 2015 10:49:07 GMT

Hi,

Go to presentation tab-> select Dimension->unselect Show Partial Sum

Regards

Re: subtotal in a Pivot table

mario-sarkis — Thu, 20 Aug 2015 09:03:25 GMT

Hi Sunny sunindia, i have a question for you i have this following expression my requirement is to ignore all selection execet several fields as shown

=(sum({ 1

< [RM User]=$::[RM User]

,[BRANCH]=$::[BRANCH]

,[RM Full Name]=$::[RM Full Name]

,[RM Party]={1}

,[RM Product/GL]={'Product'}

,Date={'$(=Date(Max(DateFinance),'M/D/YYYY'))'}

} Balance))

but the problem is the selection on for example YEAR and Month still effect the expression when i comment the date field in the expression they will not effect it as shown:

=(sum({ 1

< [RM User]=$::[RM User]

,[BRANCH]=$::[BRANCH]

,[RM Full Name]=$::[RM Full Name]

,[RM Party]={1}

,[RM Product/GL]={'Product'}

// ,Date={'$(=Date(Max(DateFinance),'M/D/YYYY'))'}

} Balance))

But i need this condition in order to get the right value.

Can you help me ?

Re: subtotal in a Pivot table

sunny_talwar — Thu, 20 Aug 2015 09:07:09 GMT

What is your chart's dimension where you are using the above expression?

Re: subtotal in a Pivot table

mario-sarkis — Thu, 20 Aug 2015 09:16:31 GMT

sunindia well i need to show is in a text object This Expression >>

=num((sum({1<[BRANCH]=$::[BRANCH],[RM Full Name]=$::[RM Full Name],DateFinance=,[RM Year]=,[RM Month]=,[RM FinalFinance Party]={1},[RM Finance Product/GL]={'Product'},DateFinance={"$(=Date(Max(DateFinance),'M/D/YYYY'))"}>}FinanceBalance))
-
(sum({1<[BRANCH]=$::[BRANCH],[RM Full Name]=$::[RM Full Name],DateFinance=,[RM Year]=,[RM Month]=,[RM FinalFinance Party]={1},[RM Finance Product/GL]={'Product'},DateFinance={"$(=Date(Max({1}{<DateFinance={'<$(=Date(Max(DateFinance),'M/D/YYYY'))'}>}DateFinance),'M/D/YYYY'))"}>}FinanceBalance)),'#,##0')

but the selection still effect it i think i should add something to the "DateFinance " here in this expression to do not change once i selet on a Year or Month field. Hope u can help.