Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

siva_boggarapu
Contributor II

Straight table chart help?

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

ProductCol1 Col2 Col3 Col4 Total
Sales=2009Saes=2008  Sales=2009Sales=2008  Sales=2009Sales=2008  Sales=2009Sales=2008
Cloth1,502,067.14

1,502,067.14

2,704,930.721,502,067.14588,569.74588,569.741,893,134.00588,569.746,688,701.60
Home Needs138,331.52138,331.52543,271.41138,331.52235,496.46235,496.46364,102.61235,496.461,281,202.00
Computers46,606.4146,606.41339,153.2446,606.4165,876.6465,876.64427,750.1065,876.64879,386.39
Electronics89,364.6189,364.61395,642.7189,364.61172,994.64172,994.6470,056.00172,994.64728,057.96
General105,644.48105,644.4896,849.44105,644.4835,159.1835,159.18329,187.0035,159.18566,840.10

Best,

Siva

1 Solution

Accepted Solutions
Highlighted
raghavsurya
Valued Contributor

Re: Straight table chart help?

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

5 Replies
MVP
MVP

Re: Straight table chart help?

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
Contributor II

Re: Straight table chart help?

HI There,

It's very urgent.

Best,

Siva

siva_boggarapu
Contributor II

Re: Straight table chart help?

Hi Swuehl,

Can you give me  some example qlikview file?

Best,

Siva

Highlighted
raghavsurya
Valued Contributor

Re: Straight table chart help?

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
Contributor II

Re: Straight table chart help?

Hello There,

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

Best,
Siva

Community Browser