topic Re: How to display total value in line chart in QlikView

How to display total value in line chart

Fri, 09 Dec 2011 09:38:23 GMT

Dear All,

How to display total value in line chart with two dimensions. In this example just treat as Month and Department as dimensions and 4 lines should be displayed 3 department and 1 is for total of all department.

Please let me know in case you need any more information.

Regards,

Ravi,

Re: How to display total value in line chart

jagan — Fri, 09 Dec 2011 09:56:40 GMT

Hi,

To achieve this you need to first change your data to this format

Department	Month	Value
Sales	Jan	10
Finance	Jan	20
IT	Jan	11
Sales	Feb	20
Finance	Feb	13
IT	Feb	22
Sales	Mar	11
Finance	Mar	14
IT	Mar	35
Sales	Apr	33
Finance	Apr	17
IT	Apr	53
Sales	May	44
Finance	May	18
IT	May	45
Sales	Jun	13
Finance	Jun	19
IT	Jun	62

Check the attachment.

Regards,

Jagan.

Re: How to display total value in line chart

Sokkorn — Fri, 09 Dec 2011 10:12:27 GMT

Hi Ravi,

Try this

1. Create new sheet with name <Sheet1 (2)> that store data like this:

Department	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Sales	10	20	11	33	44	13	43	56	44	66	55	22
Finance	20	13	14	17	18	19	20	33	22	11	34	22
IT	11	22	35	53	45	62	62	33	22	11	31	11

2. Load data from new sheet <Sheet1 (2)>

[Data]:
CrossTable(Months, Amount,1)
LOAD Department, 
     Jan, 
     Feb, 
     Mar, 
     Apr, 
     May, 
     Jun, 
     Jul, 
     Aug, 
     Sep, 
     Oct, 
     Nov, 
     Dec
FROM
[Copy of Sample Line Chart.xlsx]
(ooxml, embedded labels, table is [Sheet1 (2)]);

3. Create line chart with

3.1 Months as dimension

3.2 Three Expression

3.2.1 SUM(Amount) as Total

3.2.2 SUM({<Department = {'Sales'} >} Amount) as Sale

3.2.3 SUM({<Department = {'Finance'} >} Amount) as Finance

3.2.4 SUM({<Department = {'IT'} >} Amount) as IT

See the same attached file also.

HTH and let me know.

How to display total value in line chart

jagan — Fri, 09 Dec 2011 10:24:22 GMT

Great Job!

Regards,

Jagan.

How to display total value in line chart

Fri, 09 Dec 2011 11:20:47 GMT

Hi All,

Thanks for your all replies, But i have one more solution which is Qlikview 11 There is option without writing any set analysis syntax we can get it.

But really thanks for yours help!.

Regards,

Ravi.