Multiple lines on line chart

[qlikuserkv]

Hi,

In my dimension I should see the days from the beginning of the year to the max date.

I want to have 3 lines on line chart.  One line should calculate the sum of sales in 2016, another line for 2017 etc

I have date format like this

Jan 1 , Feb 1 ...

My chart should look like this

is it possible?

I calculate the  sum of sales in 2018  using this formula: SUM({$<Year = {'$(=Max(Year))'}, Month =, Quarter = , date = >}FactSoldAmount)

When I add another dimension for the previous year SUM({$<Year = {'$(=Max(Year)-1)'}, Month =, Quarter = , date = >}FactSoldAmount) lines aren't shown together. At first I see sum of sales in 2017 from January to April, and then I see sum of sales in 2018 from January to April

[petter]

Add two dimensions: Month and Year and simply one measure without set expression: Sum(Sales)

Or the measure: Sales( {<Quarter=,Month=>} Sales)

Or: Sales( {<Year={$(=Max(Year)),$(=Max(Year)-1),$(=Max(Year)-2)},Quarter=,Month=>} Sales)

[qlikuserkv]

But I want to show the sum of sales only the period ( from the beginning of the year to the max date information)

In my script I have ----- Date(date,'MMM D') as MonthDay

and I use MonthDay in dimension.When I add year it doesn't show the sum of sales in these 3 years

[petter]

Then just use MonthDay instead of Month and try what I suggested.

[petter]

You should only have one measure. The addition of Year as a dimension is only possible if you have one measure. So you will end up with two dimensions and one measure. The aggregations (Sum, Count,Avg .... etc) should always be added as measures.

[qlikuserkv]

Lines aren't shown together again

Measure : SUM({$<Year={$(=Max(Year)),$(=Max(Year)-1),$(=Max(Year)-2)}, Month =, Quarter = , date = >}Sale)

Dimension: MonthDay, Year

[petter]

It works well for me:

YearDayNo has been calculated in the load script as:

Dual(Date(Date,'MMM D'),DayNumberOfYear(Date)) AS YearDayNo

[qlikuserkv]

I only have one measure :

Measure : SUM({$<Year={$(=Max(Year)),$(=Max(Year)-1),$(=Max(Year)-2)}, Month =, Quarter = , date = >}Sale)

and Two dimensions :

Dimension: MonthDay, Year

[qlikuserkv]

It works for me too

But it doesn't show only the day from January to Max date information ( April)

[qlikuserkv]

I did it

I used dimension: YearDayNo

And my measures are : sum({$<Year = {$(=max(Year))}>}Sales)        for    2018

  =Sum({$<Date = {">=$(=YearStart(AddYears(Max(date), -1)))<=$(=MonthEnd(AddYears(Max(date), -1)))"}>}Sales)    for    2017    

  =Sum({$<Date = {">=$(=YearStart(AddYears(Max(date), -2)))<=$(=MonthEnd(AddYears(Max(date), -2)))"}>}Sales)      for 2016