topic Re: LINECHART in QlikView

LINECHART

manoranjan_d — Thu, 07 Jul 2016 06:59:31 GMT

year	month	dept	AMT
2016	JAN	CSE	100
2016	FEB	IT	200
2016	MAR	EEE	300
2016	APR	CSE	400
2015	JAN	CSE	500
2015	FEB	IT	600
2015	MAR	EEE	700
2015	APR	CSE	800
2015	MAY	EEE	900
2015	JUNE	CSE	1000

Hi all

above is my data, i need line chart for the total incoming spend amt by dept, for the year and month.

so can i achieve this chart? which will come for dimension and expression

Re: LINECHART

Thu, 07 Jul 2016 07:30:04 GMT

List Box Items:

Year

Month

Dimension:

dept

Measure:

sum(AMT)

Re: LINECHART

manoranjan_d — Thu, 07 Jul 2016 07:31:04 GMT

can u send me in anqvw file

Re: LINECHART

MindaugasBacius — Thu, 07 Jul 2016 07:37:28 GMT

LOAD year, 
     month,
     year &  month as year_month,
     dept, 
     AMT
FROM
[https://community.qlik.com/thread/224067]
(html, codepage is 1257, embedded labels, table is @1);

Result:

Re: LINECHART

MindaugasBacius — Thu, 07 Jul 2016 07:39:48 GMT

Also, in my opinion you will have to make a Master Calendar to succeed for aim.

Re: LINECHART

Thu, 07 Jul 2016 07:40:02 GMT

See Attached.

The best way to learn on qlik is to give it a go!

Regards,

Re: LINECHART

manoranjan_d — Thu, 07 Jul 2016 07:54:11 GMT

in line chart how many dimension are accepted? till 2 dimensions?

Re: LINECHART

Thu, 07 Jul 2016 08:01:57 GMT

As many as you require your analysis to cover or is visually and analytically intuitive.

Re: LINECHART

manoranjan_d — Thu, 07 Jul 2016 08:39:14 GMT

in line chart i need center line of vertical, this can be achieved?