topic Re: Only show Expression in partial sum in QlikView

Only show Expression in partial sum

Fri, 07 Jun 2013 06:43:17 GMT

In the below pivot table, there are 2 expressions (Player, Local Player), and LocalPlayer is Player who come from City D.

However, I just want to show the grand total of LocalPlayer on the table. (I don't want the break down of LocalPlayer).

Does anyone know how to do it? Thanks!

Re: Only show Expression in partial sum

Tue, 11 Jun 2013 03:02:22 GMT

Seems that it is impossible to hide the expression and only show the partial sum

Re: Only show Expression in partial sum

Tue, 11 Jun 2013 13:27:22 GMT

Hi,

you can try some workaround. Show Design Grid, go to Local Player column and with right clik select Custom Format Cell, Copy Background color and paste it on Text Color.

Hope this helps.

Best,

Yani

Re: Only show Expression in partial sum

Thu, 13 Jun 2013 06:37:42 GMT

Hi Yani, thank you for your idea,

There are still some problems to me after using your advice.

First, i hide only the data of column "LocalPlayer",

but in the column of "LocalPlayer",, the data for rows of "No. of Players in Country" and "Total Points in Country" are not hidden.

Then, I go ahead to hide these 2 rows using the same method above,

this time I can hide all the column of "Local-Player",

but the Grand total of the column of "Local-Player" are hidden too, but I want to show the Grand total for the "Local-Player"

What can I do next?

Re: Only show Expression in partial sum

Thu, 13 Jun 2013 10:53:50 GMT

Hi,

for me it works well, maybe its not workaround for every keys. You can try something else in expressions for player and local player type if statement.

if( Dimensionality()=0, expression)

Hope this helps.

Best,

Yani

Re: Only show Expression in partial sum

Fri, 14 Jun 2013 01:06:52 GMT

Yani,

if i use if-dimensionality function, it hides the grand total as well.

I have another problem posted in the forum, but other people fix the problem and work well too.
http://community.qlik.com/message/355466

Maybe because I use Personal Edition.

Anyway, Thanks!