Qlik Community

Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
New 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
Highlighted
Partner
Partner

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

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