Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 .
please post some sample data or sample app
Or See my post here
Headings that span multiple columns in a pivot table