X-axis no correct when displaying this years amount and last year same period

[Mazarinen]

Hello, I am new to Qlik and would like to display this years amount and last years same period in the same graph.

But I want the time period on the x-axis to show only this year and not both like in the first picture.

what I want my line chart to look like is this, but I can't get it to work, how do I get the measures to be "on top" of each other? 

Br M.

[cristianj23a · Accepted solution]

Hi, you create 2 measures by filtering the years you want to display and add those measures to the chart.

I send you some test data.

Data:

LOAD * INLINE [

YearMonth, Sales

202101, 1000

202102, 1200

202103, 900

202104, 1100

202105, 1300

202106, 950

202107, 1050

202108, 1400

202109, 1250

202110, 1600

202111, 1350

202112, 1700

202201, 1800

202202, 2000

202203, 1900

202204, 2100

202205, 2200

202206, 1950

202207, 2050

202208, 2400

202209, 2250

202210, 2600

202211, 2350

202212, 2700

];

Table:

Load YearMonth,

Right(YearMonth,2) as Month,

     Num(Right(YearMonth,2),'00') as NumMonth,

     Left(YearMonth,4) AS Year,

     Sales

Resident Data;

Drop Table Data;

Set analisys:

Max Year:

Sum({<Year= {"$(=Max(Year))"} >} Sales)

Min Year:

Sum({<Year= {"$(=Max(Year)-1)"} >} Sales)

Regarts.