topic Re: Create Table on Qlikview With multi- valued Expression in QlikView

Create Table on Qlikview With multi- valued Expression

ghassanaldalati — Wed, 25 Nov 2020 16:16:04 GMT

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

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

Re: Create Table on Qlikview With vertical and horizontal Expression

kamielrajaram — Tue, 25 Apr 2017 12:41:32 GMT

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

Re: Create Table on Qlikview With multi- valued Expression

ghassanaldalati — Tue, 25 Apr 2017 12:49:06 GMT

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 .

Re: Create Table on Qlikview With multi- valued Expression

vinieme12 — Tue, 25 Apr 2017 12:54:13 GMT

please post some sample data or sample app

Re: Create Table on Qlikview With multi- valued Expression

vinieme12 — Wed, 26 Apr 2017 11:47:50 GMT

Or See my post here

Headings that span multiple columns in a pivot table