topic pivot or straight tables in QlikView

pivot or straight tables

sakamsureshbabu — Mon, 20 Oct 2014 10:32:51 GMT

BRANCHCODE	GROSS WEIGHT	GROSS AMOUNT	BRAND
CHN	4119025.31	₹ 8803210351.39	44114.345
ERD	3737681.48	₹ 8448415540.61	67664.341
VSG	3468710.73	₹ 7618574411.12	53959.261
SLM	3095072.86	₹ 6509850581.15	20332.514
THP	2875709.47	₹ 6590547784.63	33794.823
KKD	2070999.78	₹ 4818731852.33	105066.807
BVM	318803.86	₹ 802308566.66	11955.417

here BRAND have five values sum, but i need those values in line by line how it is impassible in pivot & straight tables

BRAND

this convert into

BRAND

BRAND1	BRAND2

Re: pivot or straight tables

mazacini — Mon, 20 Oct 2014 14:59:08 GMT

It can certainly be done with a Pivot.

Say you want to analyse by Gross Weight.

Add the dimension Brand.

Add expression: sum([GROSS WEIGHT])

This will result in a table with Brands listed in the left hand column.

Simply drag the column up to the top row.

Hover over Columns label BRAND. Click+drag - you will see a blue arrow appear as a guide -drag it over the label for the column containing the expression on the right hand side.

Release the mouse.

Hope that helps.

Joe