Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ghassanaldalati
Contributor III
Contributor III

Create Table on Qlikview With multi- valued Expression

Dear All...

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

       

Dimention  >Company1Company2Company3Total Company's
  ExpressionsAchievementTarget%AchievementTarget%AchievementTarget%AchievementTarget%
Sales Amount1000200050%1000400025%500500100%2500650038%
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

4 Replies
kamielrajaram
Creator III
Creator III

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
Contributor III
Contributor III
Author

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
Champion III
Champion III

please post some sample data or sample app

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

Or See my post here

Headings that span multiple columns in a pivot table

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.