QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Contributor

Budget Sales set analysis in line chart help!

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

Tags (1)
1 Solution

Accepted Solutions

Re: Budget Sales set analysis in line chart help!

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

talk is cheap, supply exceeds demand
6 Replies
Honored Contributor

Re: Budget Sales set analysis in line chart help!

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.

Contributor

Re: Budget Sales set analysis in line chart help!

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

Not applicable

Re: Budget Sales set analysis in line chart help!

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!

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

talk is cheap, supply exceeds demand
Contributor

Re: Budget Sales set analysis in line chart help!

Hi Carmen,

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

but no go

Peter

Contributor

Re: Budget Sales set analysis in line chart help!

Hi Gysbert,

thankyou  champ!

after a bit of testing and fixing my errors it works

thnaks again

regards Peter