topic Sales vs Quota in QlikView

Sales vs Quota

Fri, 05 Aug 2011 12:49:34 GMT

Can somebody tell me, how do calculating the "Sales vs Quota"? I have no Idea... I can show that via a bar diagram... but I need figures...

I have sum(Sales) and sum(Quota) and now I don't know how use these both ....

Regards
Jenni

Sales vs Quota

Anonymous — Fri, 05 Aug 2011 13:40:37 GMT

Hi Jenni

I am assuming you would want these on a bar chart Expression 1: sum(sales), Expression 2:(sum(Quota), then you ahve choice of having them side by side or setting the style to Stacked or something.

More info regarding what you want to see would be required.

Sales vs Quota

Fri, 05 Aug 2011 13:45:13 GMT

Hi Shay Cooper!

I dont want that in Bar-Chart..to present in bar chart is really easy..but I want to compare the result of that, so I would like to do for example in a table diagram, which I can read the figures... And I can compare with my validation document, you know what I mean?

Sales vs Quota

SunilChauhan — Fri, 05 Aug 2011 13:49:48 GMT

ten take two exp in pie charts

Sales vs Quota

its_anandrjs — Fri, 05 Aug 2011 13:54:12 GMT

Hi Jenni,

As i understand you want fiqures please use pivot table or straight table.

If you have any sample please share it.

Regrads,

Anand

Sales vs Quota

Fri, 05 Aug 2011 13:58:43 GMT

thanks guys to try to help me....

Yes I want figures..... Because I want just check if my output is correct...
But HOW I can do that in a formula? so I have sum(Sales) and sum(Quota) and how can I put these both date in formula to get figures...
Ok will use the Pivot Table.. but I don't know how is the forumula for Sales vs. Quota ...

Sales vs Quota

its_anandrjs — Fri, 05 Aug 2011 14:01:26 GMT

Hi Jenni

Can you share any sample data or Qlikview Application. It will be more easy.

Regards,

Anand

Sales vs Quota

SunilChauhan — Fri, 05 Aug 2011 14:03:12 GMT

i believe it should be different formula for both Sales and quota.

comparion means calculation two seprate formula

so that it will give one sales amount and one quota(will come directly from field)

may be quota comes directly like Budgeted in Actual vs Budgeted

Sales vs Quota

its_anandrjs — Fri, 05 Aug 2011 14:04:02 GMT

Hi Jenni,

If you want to use sum(Sales) and sum(Quota) data to calculate in this case please make a variable for that like

vSumVariable=sum(Sales),

vQuotaVariable=sum(Quota)

Please share any sample.

Regards,

Anand

Re: Sales vs Quota

Fri, 05 Aug 2011 14:08:40 GMT

Okay, I have there two Diagram... I want just with the Pivotable.. I want just see the figures... because I need to check, if my output ist correct or not....

Re: Sales vs Quota

Fri, 05 Aug 2011 14:18:40 GMT

with this doc I have to check....

Sales vs Quota

SunilChauhan — Fri, 05 Aug 2011 14:20:03 GMT

sales vs quota will be

sum(sales)/sum(quota) show this in condition

Re: Sales vs Quota

Fri, 05 Aug 2011 14:22:19 GMT

show this in condition? what u mean? I did sum(sales)/sum(quota) , but I get wrong outputs....

Re: Sales vs Quota

its_anandrjs — Fri, 05 Aug 2011 14:25:36 GMT

Hi Jenni

See the attachment and confirm please in Sales vs Quota what calculation you want. i do some changes check there it is according to you or not.

Please confirm me.

Regards,

Anand

Sales vs Quota

SunilChauhan — Fri, 05 Aug 2011 14:27:36 GMT

mu god its Sum(sales)-Sum(quota)

Re: Sales vs Quota

Anonymous — Fri, 05 Aug 2011 14:27:43 GMT

Jenny the calculation you need is Sales - Quota i know this i recognise data from certification lol sales people assigned quota every quarter, minus sales per quarter from quota to find out if they met their target.

Re: Sales vs Quota

Fri, 05 Aug 2011 14:29:37 GMT

Thanks first! I did also the same things like u, but If you see my pic which I added here, there figures aren't the same ... I did sales-quota and then I tried sales/quota....

Sales vs Quota

Anonymous — Fri, 05 Aug 2011 14:32:37 GMT

What date period are you looking it, remember quota is per quarter sales is not, if you simply sum quota for one month you will get quota effectively 3 times, if you want quota less than a quarter try dividing by three

Sales vs Quota

Fri, 05 Aug 2011 14:33:02 GMT

yes that is the certification... but I am lost with this Quota....
I will try.. what u told me...

Sales vs Quota

Fri, 05 Aug 2011 14:34:03 GMT

Thanks to all of you guys!!!!!