Create Table on Qlikview With multi- valued Expression

[ghassanaldalati]

Dear All...

can I Create ( Pivot or Straight)Table on Qlikview With multi- valued Expressions with vertical Dimensions as Example:

Dimention  >	Company1			Company2			Company3			Total Company's
Expressions	Achievement	Target	%	Achievement	Target	%	Achievement	Target	%	Achievement	Target	%
Sales Amount	1000	2000	50%	1000	4000	25%	500	500	100%	2500	6500	38%
Cost Of Sales
Total Expenses
Margin Profit
Other Expenses
Net Profit
Collection

if I have all required Dimensions and Expressions

my Dimensions ( company's Name : Company 1 + 2 + 3 )

my Expressions (Sales Amount-Cost Of Sales-Total Expenses-Margin Profit-Other Expenses-Net Profit-Collection) as three multi- valued ( Target and Achievement and percentage )

your cooperation and help highly appreciated.

Regards

[kamielrajaram]

Hi,

Use a pivot table, show fully expanded. Click on the Dimension column name and move the mouse, a blue line with an arrow should appear. drag the dimension column above the expression and then do the same for the expression, click on a column header and drag to the left, this will move your expressions vertically. This should give you the desired output.

Kind regards

Kamiel

[ghassanaldalati]

Sorry Dear Kamiel..

actually each of my expressions have tow value ( Target and Achievement )

i wan't to compare between Target and achievement for each expressions as table above.with percentage .

[vinieme12]

please post some sample data or sample app

[vinieme12]

Or See my post here

Headings that span multiple columns in a pivot table