topic Re: Pivot table sub-total for 1 column should not be shown ... help? in QlikView

Pivot table sub-total for 1 column should not be shown ... help?

Anonymous — Thu, 11 Aug 2011 09:20:24 GMT

I have a Pivot table which also shows sub-totals for the expression columns. The last column contains an expression which determines to show the content or not (e.g. budget below 10.000 is not shown) ... but with the count this is shown.

See picture below (the green marked column sub-total):

Anyone got suggestions how to solve this?

The expression used in the mentioned column:

if(
 count({<Year =, Month=, Quarter=,Week=,Day= >}total  <Projectnr>  if(Project.ProjectType = 'Project',Project.ProjectType)) > 0
and 
([Budget] >= 10000 or [Budget] = 0)
, [Budget] - [Totaal project])

thx in advance!!
 

Anita

Re: Pivot table sub-total for 1 column should not be shown ... help?

lironbaram — Thu, 11 Aug 2011 09:51:16 GMT

hei

attach is an example

but basicly change your expression to

if(rowno()>0 and
count({<Year =, Month=, Quarter=,Week=,Day= >}total <Projectnr> if(Project.ProjectType = 'Project',Project.ProjectType)) > 0

and
([Budget] >= 10000 or [Budget] = 0)

, [Budget] - [Totaal project])

Re: Pivot table sub-total for 1 column should not be shown ... help?

Anonymous — Thu, 11 Aug 2011 10:46:32 GMT

Hi,

Didn't think of that ... so the normal rows are > 0 and the (sub) total rows have rownr 0?

Guesse for now I can solve this problem with your suggestion.

I thought I had to use something like aggr.

rgrds Anita