Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ilanbaruch
Specialist
Specialist

daily budget / target

Hi All,

i want to calculate daily score for sales rep  target and to present in a straight/pivot the accumulated performance value .

i.e : if sales rep have reached daily target by

day 1 :80% he gets 0.8 point

day 2 :90% 0.9 point

day 3: 100% 1 point

calculate total points for selected period (without day dimension in the table)

any ideas ?

Advanced thanks

2 Replies
kfoudhaily
Partner - Creator III
Partner - Creator III

can you provide details about your data model?

if possible please share a sample of your data.

regards,

QlikView Qlik Sense consultant
ilanbaruch
Specialist
Specialist
Author

datetargetsalesscore
01/01/2018100900.9
02/01/20181201201
03/01/20181501400.93

total score is the requested calculation/expression