Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

remove grand total from one column

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

6 Replies
oknotsen
Honored Contributor III

Re: remove grand total from one column

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".

May you live in interesting times!
MVP
MVP

Re: remove grand total from one column

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, '')

kunkumnaveen
Contributor III

Re: remove grand total from one column

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

pradeepreddy
Valued Contributor II

Re: remove grand total from one column

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),'' )

Test.png

Not applicable

Re: remove grand total from one column

hi can you please share your qvd file

to get the solution faster

oknotsen
Honored Contributor III

Re: remove grand total from one column

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

May you live in interesting times!
Community Browser