topic Re: % age issue in QlikView

% age issue

paulwalker — Sat, 04 Jan 2014 14:48:42 GMT

Hi Community,

PFA,

I am using % age Expression

sum(variance)/sum(total varience)

but it does't show % age value

--Paul

Re: % age issue

swuehl — Sat, 04 Jan 2014 14:54:37 GMT

You can't reference an expression label in another aggregation function like sum(Variance) [variance being an expression label).

It seems to me that you want to calculate

=sum(Qty) / sum(TOTAL Qty)

[and set the number format to percentage].

Re: % age issue

paulwalker — Sat, 04 Jan 2014 14:57:10 GMT

Hi Swuehl,

Sorry i am using count({$<[Type of Data] = {'Forecast'}>} Qty)

not a Sum

Re: % age issue

swuehl — Sat, 04 Jan 2014 15:02:29 GMT

That's not what I see in your sample app. But it doesn't really matter.

You can't reference an expression label inside another aggregation function (sum(), count(), avg(), min(), ...).

You need to either replicate the expressions (and maybe use advanced aggregation), or rethink your expression (like above, the sum of your first two expressions is just an aggregation with no filter, since the first two sum()s are complementary filtered.

Re: Re: % age issue

paulwalker — Sat, 04 Jan 2014 15:50:11 GMT

here i want to calculate variance % age only

[Type of Data] column name, but i have different type of field data..

Please find Attachment fine once......

Re: Re: Re: % age issue

swuehl — Sat, 04 Jan 2014 16:16:38 GMT

Ok, then just replicate your original expression for the denominator with the TOTAL qualifier:

=Variance /

(Count(TOTAL {$<[Type of Data] = {'Forecast'}>} Qty) + Count(TOTAL {$<[Type of Data] = {'Actual'}>} Qty))