Project line chart with milestones - date on y axis

[#1]

Hi i need some help configuring my line graphs in qlikview.

I want my graphs to appear as they do in the MS Excel screenshot below.

However im having problems configuring my dimensions and expressions to get the Planned/Expected dates on the Y-axis.

Any help would be much appreciated??

[#2 · Accepted solution]

Hi,

You just have to take Milestone as the dimension and Planned Date and Expected Date as expression, then specify in the number tab that the two expressions are dates. Uncheck Forced0 in the axes tab and you've got your graph.

Ps: using qv 10

[#3]

hi renaud, could you attach an example as i still cant get this too work???

[#4]

I can... but I only have a personnal edition, have you got a licensed qv ?

[#5]

Yes i have a licenced version, and i have got it to work now

Many thanks for your help