topic Re: remove grand total from one column in QlikView

remove grand total from one column

kunkumnaveen — Wed, 10 Feb 2016 12:43:03 GMT

Hello guys ,can any one help me to getrid of this grand total for a particular expression in my case the column called % of total for that column i dont to see grand total i tried to rid of it through presentation tab but its not working in my case is there any another way to get rid of that .please find the attachment

thanks

naveen

Re: remove grand total from one column

oknotsen — Wed, 10 Feb 2016 12:47:14 GMT

Go to the Expressions tab.

Select the expression you do not want to see a total.

In the bottom right of the Expression tab select "No Totals".

Re: remove grand total from one column

swuehl — Wed, 10 Feb 2016 12:54:43 GMT

Well, since it's a pivot table, the 'No Totals' options on expression tab is disabled.

I think you need to work around this using a Dimensionality() check:

Modify your current expression like

=If(Dimensionality()>0, YourCurrentExpression, '')

Re: remove grand total from one column

kunkumnaveen — Wed, 10 Feb 2016 12:55:46 GMT

Hello onno ,Even i was trying to do that but in my expression tab the NO TOTAL is graded out,please see that attachment

thanks

naveen

Re: remove grand total from one column

PradeepReddy — Wed, 10 Feb 2016 13:34:16 GMT

take Year-->Quarter-->Month as dimension

Expression: Sum(Sales)

Expression: Count(OrderID)

If u don't want to showcase Total for Count(Orders) expression, try like this..

IF(Dimensionlaity()=3,Count(OrderID),'' )

Re: remove grand total from one column

Wed, 10 Feb 2016 13:40:43 GMT

hi can you please share your qvd file

to get the solution faster

Re: remove grand total from one column

oknotsen — Wed, 10 Feb 2016 14:27:29 GMT

Sorry; my bad. I assumed it was a Straight Table as I did not open the PPT.