Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
rkspareek1992
Partner - Creator
Partner - Creator

Shw

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.

                                                                                                                                                                   

Table1Table2
PlantMaterialProductionRecoveryPlantMaterialSales
100110001102010011000110
100210001203010021000120
100310001304010031000130
100110002401010011000240
100210002503010021000250
100310002604010031000260
100110003704010011000370
100210003803010021000380
100310003904010031000390

                                                                                                                                                                   

Table1Table2
PlantMaterialProductionRecoveryPlantMaterialSales
100110001102010011000110
100210001203010021000120
100310001304010031000130
100110002401010011000240
100210002503010021000250
100310002604010031000260
100110003704010011000370
100210003803010021000380
100310003904010031000390

           

Output1
Sales450
Production450
Recovery280

                                                           

Output2
DimensionPlantTotal
Sales1001120
Sales1002150
Sales1003180
Production1001120
Production1002150
Production1003180
Recovery100170
Recovery100290
Recovery1003120
13 Replies
chinnuchinni
Creator III
Creator III

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(Salestest.PNG)

gawalimegha
Contributor III
Contributor III

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.

output.PNG

rkspareek1992
Partner - Creator
Partner - Creator
Author

Hi,

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

arvind1494
Specialist
Specialist

Hi Rakesh,

Please download the attachment and try to understand.

Capture1.PNG