# New to QlikView

Discussion board where members can get started with QlikView.

Contributor II

## Straight table chart help?

Hi Everyone,

I have one stright table like below.

#### 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
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

## 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.

Contributor II

## Re: Straight table chart help?

HI There,

It's very urgent.

Best,

Siva

Highlighted
Contributor II

## Re: Straight table chart help?

Hi Swuehl,

Can you give me  some example qlikview file?

Best,

Siva

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

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