Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

caccio88
New Contributor III

How to display Roll 12 Month Last Year in the same chart?

Hi everyone,

i've just created a chart in which is possible to display the last 12 month in roll.
But now my issue is to display in the same chart the value of last month-year. Where the dimension is June 2011, I would like to display the sales of June 2011 and the sales of June 2010...where the dimension is May 2011, I would like to display the sales of May 2011 and the sales of May 2010...etc...

I hope I was clear enough.


I attach here my qvw to solve it.


gwassenaar‌ i'm sure you can help me...


Tags (1)
1 Solution

Accepted Solutions

Re: How to display Roll 12 Month Last Year in the same chart?

May be this:

Capture.PNG

Expression for LY

If(Actual > 0, Above(Sum({<YearMonth = >}Sales), 12))

5 Replies

Re: How to display Roll 12 Month Last Year in the same chart?

May be this:

Capture.PNG

Expression for LY

If(Actual > 0, Above(Sum({<YearMonth = >}Sales), 12))

caccio88
New Contributor III

Re: How to display Roll 12 Month Last Year in the same chart?

That's what i was looking for. Thank u so much sunindia‌!!!

Re: How to display Roll 12 Month Last Year in the same chart?

No problem

I am glad I was able to help.

Best,

Sunny

caccio88
New Contributor III

Re: How to display Roll 12 Month Last Year in the same chart?

Hi sunindia‌,

do u know why when I filter a single month it can't be displayed the LY value?

Could u see my new attachment here please?

thx as usual

Re: How to display Roll 12 Month Last Year in the same chart?

You made a selection in DateMonth field, all the calendar field where you might make a selection need to go in here for the expression to work properly:

If(Actual > 0, Above(Sum({<YearMonth = , DateMonth = , OtherCalendarFields = >}Sales), 12))

Community Browser