Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ziabobaz
Contributor II

Chart 90-days rolling, when no sales data on certain dates

Hi!

The below formula works great on a chart with DATE Dimension.

   sum(

   Aggr(RangeSum(Above(

     Sum(Sales), 0, 90)), ([Date],(NUMERIC,ASCENDING)))

)

There is one exception: if there were no sales on certain days, it continue to sum up the values, until it gets 90 records in total (not calendar days).

Is there other way to show rolling Sales based on number of Calendar days, rather than number or rows?

Thank you!

1 Solution

Accepted Solutions
ziabobaz
Contributor II

Re: Chart 90-days rolling, when no sales data on certain dates

Solved.

I turned on "Show zero values" in chart / table properties.

1 Reply
ziabobaz
Contributor II

Re: Chart 90-days rolling, when no sales data on certain dates

Solved.

I turned on "Show zero values" in chart / table properties.

Community Browser