topic Re: Expression in my pivot table - exceeding 100% in QlikView

Expression in my pivot table - exceeding 100%

Wed, 26 Sep 2012 10:03:24 GMT

Hello,

As you surely will tell from this post, I am new to QV10, and have a problem creating an expression in a pivot table.

My data has Country and State as dimensions.

My expressions are

SUm({<month_name ={June}>} (Numerator)/(Denominator))

Same for July, August etc

This works fine when the pivot table is opened down to State, but when grouped up to Country, the % for the country is just the addition of all the state %'s; not the recalculation.

Please can someone show me where I am going wrong?

Thanks in advance.

Re: Expression in my pivot table - exceeding 100%

whiteline — Wed, 26 Sep 2012 10:52:28 GMT

Hi.

Your expression is wrong for Country level. You have more than one value for Numerator and Denominator on this level.

You should use aggregation functions, for example like this:

=sum({<month_name ={June}>} Numerator)/sum({<month_name ={June}>} Denominator)

Re: Expression in my pivot table - exceeding 100%

Wed, 26 Sep 2012 10:56:39 GMT

Thanks for the giudance.

Re: Expression in my pivot table - exceeding 100%

Wed, 26 Sep 2012 10:56:47 GMT

Thanks for the giudance.

Re: Expression in my pivot table - exceeding 100%

Wed, 26 Sep 2012 10:56:56 GMT

Thanks for the giudance.

Re: Expression in my pivot table - exceeding 100%

Wed, 26 Sep 2012 10:58:19 GMT

Thanks for the giudance.

Re: Expression in my pivot table - exceeding 100%

Wed, 26 Sep 2012 11:12:20 GMT

Thanks for the giudance.