Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
sakamsureshbabu
Creator
Creator

pivot or straight tables

hi

BRANCHCODE GROSS WEIGHTGROSS AMOUNTBRAND
CHN4119025.31 ₹ 8803210351.3944114.345
ERD3737681.48 ₹ 8448415540.6167664.341
VSG3468710.73 ₹ 7618574411.1253959.261
SLM3095072.86 ₹ 6509850581.1520332.514
THP2875709.47 ₹ 6590547784.6333794.823
KKD2070999.78 ₹ 4818731852.33105066.807
BVM318803.86 ₹ 802308566.6611955.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
BRAND1BRAND2
1 Reply
mazacini
Creator III
Creator III

Hi

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