topic Re: Calculating Market Share in QlikView

Calculating Market Share

Thu, 24 Sep 2015 08:19:15 GMT

I have below table in market share I want total of Year. its working fine but value is showing in 1st row of every year.

I have used aggr function =aggr(sum(Sale),Year).

I want to show total of 2012 of every row of 2012 and total of 2013 in every row of 2013 and so on.

Thanks,

Maksood Alam

Re: Calculating Market Share

simenkg — Thu, 24 Sep 2015 08:23:49 GMT

sum(Total <Year> Sale)

Re: Calculating Market Share

Thu, 24 Sep 2015 08:35:34 GMT

Thanks Simen

Re: Calculating Market Share

simenkg — Thu, 24 Sep 2015 09:06:23 GMT

No problem

The thing you actually asked about is the reason why your expression only gives you the value in the first row. This is because the Aggr function is distinct by default, meaning it will only populate one of the lines. So to specifically answer your question, you can use the function =aggr(NODISTINCT sum(Sale),Year).

However, the reason I replied with the above expression is because its performance is much better and in this case will yield the right answer.

Regards

SKG

Re: Calculating Market Share

Thu, 24 Sep 2015 09:13:08 GMT

Cool..

I got your point. Thank you very much Simen for explaining this point. It's really very helpful.