How to create continuous line chart with weeknames - Qlik Community

florian_guggane · ‎2017-10-24

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

Anonymous · ‎2017-10-24

Have you tried

weekname(YourDayDate) as WeekNo

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

florian_guggane · ‎2017-10-25

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.

Anonymous · ‎2017-10-25

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

(Assuming you're in Qlikview)