topic Re: Straight table chart help? in QlikView

Straight table chart help?

siva_boggarapu — Thu, 21 Jun 2012 09:13:46 GMT

Hi Everyone,

I have one stright table like below.

Product	Col1	Col2	Col3	Col4	Total
	2,116,704.34	4,576,615.28	1,629,538.75	3,295,270.88	11,618,129.25
Cloth	1,502,067.14	2,704,930.72	588,569.74	1,893,134.00	6,688,701.60
Home Needs	138,331.52	543,271.41	235,496.46	364,102.61	1,281,202.00
Computers	46,606.41	339,153.24	65,876.64	427,750.10	879,386.39
Electronics	89,364.61	395,642.71	172,994.64	70,056.00	728,057.96
General	105,644.48	96,849.44	35,159.18	329,187.00	566,840.10

I want to make this chart like below year wishe sales. How it is possible in stright table

Product	Col1		Col2		Col3		Col4		Total
	Sales=2009	Saes=2008	Sales=2009	Sales=2008	Sales=2009	Sales=2008	Sales=2009	Sales=2008
Cloth	1,502,067.14	1,502,067.14	2,704,930.72	1,502,067.14	588,569.74	588,569.74	1,893,134.00	588,569.74	6,688,701.60
Home Needs	138,331.52	138,331.52	543,271.41	138,331.52	235,496.46	235,496.46	364,102.61	235,496.46	1,281,202.00
Computers	46,606.41	46,606.41	339,153.24	46,606.41	65,876.64	65,876.64	427,750.10	65,876.64	879,386.39
Electronics	89,364.61	89,364.61	395,642.71	89,364.61	172,994.64	172,994.64	70,056.00	172,994.64	728,057.96
General	105,644.48	105,644.48	96,849.44	105,644.48	35,159.18	35,159.18	329,187.00	35,159.18	566,840.10

Best,

Siva

Re: Straight table chart help?

swuehl — Thu, 21 Jun 2012 11:07:51 GMT

Do you need to stick with a straight table? It seems to me that a pivot table might be more appropriate for what you want to achieve.

If Col1 to Col4 are a fixed number of main columns, you could probably work out a solution using a straight table with dimension Product and an expression per combination of Col and Sales Year.

Re: Straight table chart help?

siva_boggarapu — Thu, 21 Jun 2012 11:07:53 GMT

HI There,

It's very urgent.

Best,

Siva

Re: Straight table chart help?

siva_boggarapu — Thu, 21 Jun 2012 11:09:55 GMT

Hi Swuehl,

Can you give me some example qlikview file?

Best,

Siva

Re: Straight table chart help?

raghavsurya — Wed, 04 Jul 2012 08:24:07 GMT

Hi Siva,

Please find attached one of the qlikview files which will address ur needs. You have to use Pivot table instead of straight table to achieve this. The attached file was downloaded from earlier qlikview community threads, not able to find that thread hence attaching the file.

Regards,

Raghav

Re: Straight table chart help?

siva_boggarapu — Fri, 06 Jul 2012 09:17:12 GMT

Hello There,

Can any one help on this as same like I posted? Eithere Straight table or Pivot table?

Best,
Siva

topic Re: Straight table chart help? in QlikView

Straight table chart help?

Product

Col1

Col2

Col3

Col4

Total

2,116,704.34

4,576,615.28

1,629,538.75

3,295,270.88

11,618,129.25

Cloth

1,502,067.14

2,704,930.72

588,569.74

1,893,134.00

6,688,701.60

Home Needs

138,331.52

543,271.41

235,496.46

364,102.61

1,281,202.00

Computers

46,606.41

339,153.24

65,876.64

427,750.10

879,386.39

Electronics

89,364.61

395,642.71

172,994.64

70,056.00

728,057.96

General

105,644.48

96,849.44

35,159.18

329,187.00

566,840.10

1,502,067.14

Re: Straight table chart help?

Re: Straight table chart help?

Re: Straight table chart help?

Re: Straight table chart help?

Re: Straight table chart help?