topic Re: Sum Total Conditional in QlikView

Sum Total Conditional

Mon, 20 Jan 2014 09:58:15 GMT

Hi,

I am trying to write a formula to calculate Market Share:

sum(if(Condition=1,Units))/sum(Total{<Condition={1},competitor>}Units)

The first part of formula(Numerator) is working. However when i use total condition in next part(denominator) it fetches no result. How can i modify the same to apply both condition?

Thanks.

Re: Sum Total Conditional

alexandros17 — Mon, 20 Jan 2014 10:07:19 GMT

Try This:

sum(if(Condition=1,Units))

sum({$ <Condition={1},competitor=>} Total Units)

... and let me know

Re: Sum Total Conditional

sujeetsingh — Mon, 20 Jan 2014 10:13:54 GMT

Try removing the total

Re: Sum Total Conditional

maxgro — Mon, 20 Jan 2014 10:21:28 GMT

sum( {$ <Condition={1}>} Units)

sum({$ <Condition={1},competitor=>} Total Units)

Re: Sum Total Conditional

Mon, 20 Jan 2014 10:22:15 GMT

It doesn’t work ☹

Re: Sum Total Conditional

Mon, 20 Jan 2014 10:22:15 GMT

It doesn’t work ☹

Re: Sum Total Conditional

alexandros17 — Mon, 20 Jan 2014 10:29:20 GMT

... so explain better what is your aim:

why do you use competitor field only in the denominator? Try with this expression for the denominator

sum({$ <Condition={1}>} Total Units) ... if it works you have to understand the problem related to competitor.

Hope it helps

Re: Sum Total Conditional

Mon, 20 Jan 2014 10:32:41 GMT

The first part of formula works. I am using competitor in the denominator because i want to total the unit sales competitor wise.

Re: Sum Total Conditional

alexandros17 — Mon, 20 Jan 2014 10:36:04 GMT

Ok, then try the expression for the denominator without competitor as I suggested in the previous message and let me know