topic Re: Distribution in QlikView

Distribution

Wed, 30 Jan 2013 19:17:26 GMT

Hello everyone,

I have a problem of distributing the amount among different channels.

i want to distribute this 100 amount in the Revenue Field among all the other channels equally in the Distribution field or like giving some percentage of the total amount.

Any suggestions or solution guys???

Thanks

Re: Distribution

Gysbert_Wassenaar — Wed, 30 Jan 2013 19:46:59 GMT

distribution: sum(total Revenue)/count(distinct Channel)

or something like sum(total Revenue)*sum(Spend)/sum(total Spend)

Change Revenue and Spend with the names of your fields (or with your expressions)

Re: Distribution

Wed, 30 Jan 2013 21:58:10 GMT

Hi Gysbert Wassenaar .. thanks for your reply but the expression

sum(total Revenue)/count(distinct Channel)

gives me the value 100 for each channel where as i want 25 for each and i also want to distribute the revenue like where consecution is 1 , i want to give 30% of the revenue etc.

Re: Distribution

Thu, 31 Jan 2013 21:01:39 GMT

hi Gysbert Wassenaar, thanks for your reply, I am attaching a sample application with this post in which i have defined the scenario what i need and explained what each field means....

It would be a great favour if you can suggest me some solution out of that.I am kind of stuk at this point.

THERE are 2 book marks called example 1 and example 2 which will explain the situation more clearly to you.Thanks for your time.

Best Regards

Re: Distribution

Gysbert_Wassenaar — Fri, 01 Feb 2013 09:36:09 GMT

See attached qvw. I didn't understand what you mean with item 3, the distribution when all selections are cleared.

Re: Distribution

Fri, 01 Feb 2013 10:32:54 GMT

Bundle of thanks Gysbert Wassenaar....I really appreciate it

Re: Distribution

Wed, 06 Feb 2013 15:24:46 GMT

Gysbert Wassenaar.

I have one more problem

Channel	Consecution	tag	spend	Revenue
AFF	1	F	10	30
PEG	2	other	10	15
SKS	3	L	10	40
AGH	4	other	10	15

in the above table i have distributed the revenue among all channel but now i donot want to give the Channel any revenue which comes after L tag..that is after the sales has been made. so i need this

Channel	Consecution	tag	spend	Revenue
AFF	1	F	10	30
PEG	2	other	10	30
SKS	3	L	10	40
AGH	4	X	10	0

how i can make X in th tag field at the script level??

I have used this expression for tag field,

If(consecution=1,'F',if(buyConsecution>=1,'L','other')))

BR!