Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Peter_Brunner
Creator
Creator

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
Anonymous
Not applicable

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.

Peter_Brunner
Creator
Creator
Author

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

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

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Peter_Brunner
Creator
Creator
Author

Hi Carmen,

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

but no go

Peter

Peter_Brunner
Creator
Creator
Author

Hi Gysbert,

thankyou  champ!

after a bit of testing and fixing my errors it works

thnaks again

regards Peter