Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dartagnan1
New Contributor

365 Day rolling sales.

I am creating my first Qlik Sense app. I have a line graph showing 365 day rolling sales data. The first years data appears as a ramp (because there is no previous year's sales data). I don't want to display the first year on the graph but obviously I need the data for the second year. How do I change the start of the X axis to the start of the second year?

1 Reply
MVP
MVP

Re: 365 Day rolling sales.

May be use an if statement

If(Date >= AddYears(Min(TOTAL Date), 1), ......)

Community Browser