topic Re: How to Set chart axis.. in QlikView

How to Set chart axis..

Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

i have a query like relation 3 columns , those needs to be displayed in chart.

execdate availability type

01 jan 78 Type1

02 jan 87 Type1

01 jan 65 Type1

03 jan 82 Type1

01 jan 75 Type2

04 jan 82 Type2

05 jan 74 Type2

03 jan 81 Type2

now i want to plot a chart like

x- axis : exec date

y axis : availability

graph should be a line graph it should draw line like the availability for the exec date against type

kindly find the attached image for reference.

qlikquery : Chart obtained in qlikview

Expected chart : Expected Chart

For me i was unable to keep exec date in x-axis and availability in y axis. please advice the necessary to achieve this.

Thanks in Advance...

With Regards

Deepak Subramoniam

Re: How to Set chart axis..

sunny_talwar — Mon, 04 Jul 2016 13:04:12 GMT

What is the expression that you have used here?

Re: How to Set chart axis..

MarcoWedel — Mon, 04 Jul 2016 21:58:56 GMT

Hi,

one solution might be:

table1:

LOAD Date#(execdate,'DD MMM') as execdate,

availability,

type

INLINE [

execdate, availability, type

01 jan, 78, Type1

02 jan, 87, Type1

01 jan, 65, Type1

03 jan, 82, Type1

01 jan, 75, Type2

04 jan, 82, Type2

05 jan, 74, Type2

03 jan, 81, Type2

];

hope this helps

regards

Marco

Re: How to Set chart axis..

Tue, 05 Jul 2016 05:00:54 GMT

Dear Marco Wedel

Thanks a lot its working , the graph was only visible only for average expression , if i change the expression to only value , then graph was not displaying instead the chart area was dispayed with a text like "No data to display".

Thanks in Advance...

With Regards

Deepak Subramoniam

Re: How to Set chart axis..

MarcoWedel — Tue, 05 Jul 2016 22:03:19 GMT

glad it worked.

please close your thread if your question is answered (by marking an answer correct)

thanks

regards

Marco