Straight table chart help?

[siva_boggarapu]

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

[swuehl]

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.

[siva_boggarapu]

HI There,

It's very urgent.

Best,

Siva

[siva_boggarapu]

Hi Swuehl,

Can you give me  some example qlikview file?

Best,

Siva

[raghavsurya · Accepted solution]

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

[siva_boggarapu]

Hello There,

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

Best,
Siva