Shw

[rkspareek1992]

Hi,

I have many data tables in below-mentioned tables (here I only showed two tables for example). Table1 consist of Production & recovery data and table2 consist of Sales data. Now My requirement is to show the data in Row-wise format as per below mentioned desired outputs. Output can be only dimension wise (as per output1) or It can be Plant or material wise (as per output2).

Kindly suggest how can I get the desired output.

Table1					Table2
Plant	Material	Production	Recovery		Plant	Material	Sales
1001	10001	10	20		1001	10001	10
1002	10001	20	30		1002	10001	20
1003	10001	30	40		1003	10001	30
1001	10002	40	10		1001	10002	40
1002	10002	50	30		1002	10002	50
1003	10002	60	40		1003	10002	60
1001	10003	70	40		1001	10003	70
1002	10003	80	30		1002	10003	80
1003	10003	90	40		1003	10003	90

Table1					Table2
Plant	Material	Production	Recovery		Plant	Material	Sales
1001	10001	10	20		1001	10001	10
1002	10001	20	30		1002	10001	20
1003	10001	30	40		1003	10001	30
1001	10002	40	10		1001	10002	40
1002	10002	50	30		1002	10002	50
1003	10002	60	40		1003	10002	60
1001	10003	70	40		1001	10003	70
1002	10003	80	30		1002	10003	80
1003	10003	90	40		1003	10003	90

Output1
Sales	450
Production	450
Recovery	280

Output2
Dimension	Plant	Total
Sales	1001	120
Sales	1002	150
Sales	1003	180
Production	1001	120
Production	1002	150
Production	1003	180
Recovery	1001	70
Recovery	1002	90
Recovery	1003	120

[chinnuchinni]

Hi Rakesh,

For output 1:

take pivot table without dimension. and expressions are

Sales: sum(Sales)

Production: sum(Production)

Recovery: sum(Recovery)

For output2:

dimensions: valuelist('Sales','Production','Recovery') , plant

expression : sum(Sales)

[gawalimegha]

Hello Rakesh,

For Output 1 you can use straight table:

1)without any dimensions. Expressions as sum([Production]), etc.

2) In presentation tab check Horizontal column.

[rkspareek1992]

Hi,

I am using Qlik sense... Kindly suggest the solution in Qliksense.

[arvind1494]

Hi Rakesh,

Please download the attachment and try to understand.