topic Re: Qlikview Linechart in QlikView

Qlikview Linechart

vijetas42 — Mon, 22 Oct 2018 07:22:53 GMT

Hi All,

Is there any way I can get the line chart based on below data,

YearMonth	Date	Value
201507	20150703	0.4
201507	20150710	0.6
201507	20150717	0.9
201508	20150807	1.2
201508	20150814	1.4
201509	20150907	1.5
201509	20150911	1.6
201510	20151002	1.7
201511	20151106	1.2
201511	20151113	0.7
201511	20151120	1.4
201512	20151204	1.8
201512	20151231	2
201601	20160108	2.5
201602	20160205	1.5
201602	20160212	0.9
201602	20160219	1.3

now, my requirement is on my x axis there will be only YearMonth but, values should get plotted based on date wise value. Which means for YearMonth 201507 there should be three data points.

Please see attached image as reference.

Regards,

Vijeta

Message was edited by: vijeta sharma

Re: Qlikview Linechart

Anil_Babu_Samineni — Mon, 22 Oct 2018 08:10:05 GMT

Why three points needed? If so, I can say Add these two dimensions and disable the Legend

Re: Qlikview Linechart

mayankraoka — Mon, 22 Oct 2018 09:02:44 GMT

H !i Vijeta,

This is how you can do.Please see screenshot and attached qvw.

Regards,

Mayank Raoka !

Re: Qlikview Linechart

vijetas42 — Mon, 22 Oct 2018 09:26:49 GMT

This I have already tried but, it's not showing lines connecting the data points

Re: Qlikview Linechart

vijetas42 — Mon, 22 Oct 2018 09:30:17 GMT

because for 201507 we have 3 dates values.Though I disable the legends my x axis will show dates only but, i need yearmonth.

Re: Qlikview Linechart

Anil_Babu_Samineni — Mon, 22 Oct 2018 09:49:33 GMT

Take First Dimension as YearMonth and Second dimension as Date

Re: Qlikview Linechart

vijetas42 — Mon, 22 Oct 2018 09:53:32 GMT

That I have tried but, it's showing chart as mayankraoka‌ shown it's not creating line which will connect my data points

Re: Qlikview Linechart

mayankraoka — Mon, 22 Oct 2018 10:24:40 GMT

Hi Vijeta,

this is what you want.Try the workaround i have provided in attached qvw.

Regards,

Mayank

Re: Qlikview Linechart

vijetas42 — Mon, 22 Oct 2018 10:41:57 GMT

In your application i can't see x axis labels. Even I have copied same chart into my application but on X-axis its showing all dates