topic Re: How to create continuous line chart with weeknames in QlikView

How to create continuous line chart with weeknames

florian_guggane — Tue, 24 Oct 2017 15:11:58 GMT

Hi,

I ran into some difficulties with the following chart:

This looks almost exactly how I wanted it to look like, except that the x-axis shouldn't be the months but the weeknumbers. I need it to be a continuous axis, because I want to add vertical reference lines to show when a year starts. Is there a way to format the continuous x-axis that the weeknames are shown?

Any help would be appreciated, thank you.

Best regards,

Flo

Re: How to create continuous line chart with weeknames

Anonymous — Tue, 24 Oct 2017 20:40:58 GMT

Have you tried

weekname(YourDayDate) as WeekNo

in your script and then use that as the dimension instead?

Re: How to create continuous line chart with weeknames

florian_guggane — Wed, 25 Oct 2017 08:47:59 GMT

Hi Wallo,

thank you for your answer. The dimension is already the weekname. As you can see, there are roughly always four datapoints per month, which indicates that. The only issue I have is that the axis itself doesn't show the weeknames anymore, if I need the axis to be continuous.

Re: How to create continuous line chart with weeknames

Anonymous — Wed, 25 Oct 2017 15:00:59 GMT

Go to properties and the Axis tab. make the static step 1.

(Assuming you're in Qlikview)