topic Re: Hi All, Line Chart Help in Qlik Learning Discussions

Hi All, Line Chart Help

Wed, 04 Mar 2015 14:01:38 GMT

Hi, I'm new to Qlikview and I need help in relation to a line chart see below.

I originally had the chart and was trying to put in 2 dimensions of week then quarter but when I try that only the week appears see below..

If anyone could help me get the 2nd dimension quarter to appear on the 'X' axis that would be great no need to worry about

the 2nd part below..

I then tried the below where the '12', '13' etc on the x axis is a combination of quarter and week so 12 is quarter 1 week 2.

Is it possible to display the 12 etc as Q1WK2

Hope the above makes sense and any help would be greatly appreciated as it all seems a bit daunting being a newbie!!

Thanks,

Dave.

Gysbert_Wassenaar — Thu, 05 Mar 2015 09:57:52 GMT

You probably should fix this in the script by creating a new QuarterWeek field there by combining the quarter and week value.

LOAD ...other fields...,

Quarter & '-' & Week as QuarterWeek

FROM ....

Thu, 05 Mar 2015 16:06:41 GMT

Thanks for your help:-)