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: 
wuensche
Contributor II
Contributor II

measure Pointer sales last year, plansale and actual sale

Hello together,

I want to do a measure pointer with segments and different colors, where I can see :

- sale of last year  per day

-plansale per day

actual sale per day

It should be dynamic, in depency of a date.

Does anybody have a idea?

wuensche_0-1595688084021.png

 

best regards

wuensche

1 Reply
tm_burgers
Creator III
Creator III

Last = sum({<year = {'=year(=date(today())) - 1'} >} sales) / 365

 

PlanSale = sum(plansale) / days if necessary 

 

Actual  = sum(actual)

 

??