Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ambasadorknz
Contributor II
Contributor II

Compare Daily sales with Sales 28-days before on bar chart

Hi,

I have to compare daily sales with sales 28-days before. 

I can do that when i select one Day:

sum({1<fl_run={1},run_year={"$(=text(year(run_year-28)))"},run_month={"$(=text(num(Month(run_month-28))))"},run_day={"$(=text(Day(run_day-28)))"}
>}sales)

but it not working for more then 1 day

Yes, I know ... i have to convert data:)

Any suggestions? Please?

Example:

 

DaySalessales -28d
2020-01-011164052989444
2020-01-021502656812772582
2020-01-031707334214512341
2020-01-0463423605391006
2020-01-0523894512031033
2020-01-0631507542678141
2020-01-071591945713531539
2020-01-081854130715760111
2020-01-091830450415558828
2020-01-101833721015586628
2020-01-1161422535220915
2020-01-1235625353028155
2020-01-131906346516203945
2020-01-142000868817007385
2020-01-151783012315155605
2020-01-161740611914795201
2020-01-1718155791543242

12j.JPG

 
 
Labels (4)
1 Reply
kashyap
Partner
Partner

Hi

If your date is not skipping then you can use this for before - 28 days

Alt(Above(Sum(Value),28),0)

Hope this helps 

thanks