Show in a linechart y and y-1 with yearweek as dimension

[qlikhalmar]

Hi All,

I have a problem with a linechart. I hope someone knows the trick to do this:

I want to make a linechart with to lines, one line with the data of THIS YEAR and one with the data of LAST YEAR.

No problem with only the weeknumber as a dimension. But I want the YearWeeknumber as a dimension so I can show the difference over the yearends.

Can anyone tell me if this is possible without loading the data twice?

I added a test qvw.

Thanks in advance!

Halmar !

[#2]

Hi.

Try like this.

[qlikhalmar]

Hi,

I know i can do it on that way, bu i want to do that with the dimension YearWeek.

[#4]

I'm sorry. I don't think it's possible.

[stigchel · Accepted solution]

You can use a synthetic dimension like ValueList, see example attached.

[stigchel]

In the meantime I have also thought of a another interesting solution for this. It does involve loading an extra dimension, but instead of twice, using a dual with the weeknr as number. This uses the fact that qv only stores the first text representation of a number it encounters for a dual, so with a descending date it will load only the most recent yearweek text representations. You can use a field year in set analysis to distinguish.

Thought that was still interesting to share, example attached.