relative dimension

Tue, 16 Dec 2014 12:34:28 GMT

hello,

I am trying to get the following result in a pivot table / line chart:

[Date Key] [Expression -Item 1] [Expression- Item 2]

200504 175717639.9 0

200505 175699534.3 0

200506 175507867.8 0

200507 175467454.4 0

200508 175473176.2 0

200509 175483460.8 40762560.51

200510 175473129.9 92267944.15

200511 175470930.4 128695316.2

200512 175473026.2 198368513.4

200601 175467824.9 212605674.6

200602 175472149.4 222178104.9

200603 175364439.2 228004593.7

200604 175312170.9 230014748.7

200605 177544690.5 233015672.8

200606 177571617.3 234152925.5

where the first column represents date( as the name suggests)

second column represents sales value correspoding to item 1 and corresponding date.

similarly, third column represents sales value correspoding to item 2 and corresponding date.

Now I want date keys as dimension and the other to columns as expression which is straight forward.

The tricky part is that I don't want to see datekeys from 200504 to 200508 for item 2. As, in I don't want to see those '0' values.

but since I have only one dimension axis, I tried to make these datekeys relative..

as in :

where 1 would mean 200504 for item 1 and 200509 for item 2

2 would mean 200505 for item 1 and 200510 for item 2

and so on...

Could anyone suggest any way to handle this? I am sorry about posting it as I have asked related questions earlier on the community. (did not get much help)

I am really looking forward to some help with this scenario... Please share the question with anyone who you think would be able to help.. would be really helpful..

Thanks..

Re: relative dimension

Gysbert_Wassenaar — Tue, 16 Dec 2014 13:03:47 GMT

See attached qvw.

topic Re: relative dimension in QlikView

relative dimension

Re: relative dimension