topic Re: Budget Sales set analysis in line chart help! in QlikView

Budget Sales set analysis in line chart help!

Peter_Brunner — Mon, 22 Oct 2012 06:15:15 GMT

Hi all,

I need a fresh set of eyes to cross check my work

I have been trying to figure out where I have gone wrong

1) I have a staright table with expression =DailyBudget*Selldays
"Total Mode" set to sum

and I get correct Data no problem!

2) I wish to do same with set analysis in Line graph chart

Sum({< Rep={'Harry'} >}DailySales) works!

=({< Rep={'Harry'} >}DailyBudget*Selldays) Does not work , if i use sum incorrect values

I have put together a example

Thanks for any help
regards Peter

Re: Budget Sales set analysis in line chart help!

Anonymous — Mon, 22 Oct 2012 06:35:37 GMT

Hi Peter,

Your table has multiple records for each DailyBudget and Selldays entry.

For example, If you look at Harry, July and area Building, you have three records with a DailyBudget of 457.69 and selldays =22. This results in the total being 30k something instead of the expected 10k.

Re: Budget Sales set analysis in line chart help!

Peter_Brunner — Mon, 22 Oct 2012 07:00:32 GMT

Hi Johannes,

thanks for quick reply

and yes you are right for Area Building in Aug, but I am looking at Totals across all Areas

as in see straight table totals , I wish to have same totals across all areas in graph chart.

So for Harry..Total. Sales $30,315 and total Budget $36,981.54 in straight table is correct

I can get Correct Sales $ 30,315 in chart as example

but can Not get correct Total $36981.54 for Harrys Budget

Peter

Re: Budget Sales set analysis in line chart help!

Mon, 22 Oct 2012 08:34:58 GMT

Hi Peter,

In order to get correct Total Budget for Harry I think you can try this expression:

=sum({< Rep={'Harry'} >} DailyBudget*Selldays)/count({< Rep={'Harry'} >} DailyBudget)

Carmen

Re: Budget Sales set analysis in line chart help!

Gysbert_Wassenaar — Mon, 22 Oct 2012 09:24:54 GMT

try: Sum({< Rep={'Harry'}>} distinct DailyBudget*Selldays)

Re: Budget Sales set analysis in line chart help!

Peter_Brunner — Mon, 22 Oct 2012 09:25:52 GMT

Hi Carmen,

thanks for your reply I see your logic with your suggestion tried several different combinations

but no go

Peter

Re: Budget Sales set analysis in line chart help!

Peter_Brunner — Mon, 22 Oct 2012 10:32:53 GMT

Hi Gysbert,

thankyou champ!

after a bit of testing and fixing my errors it works

thnaks again

regards Peter