Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
settu_periasamy
Master III
Master III

Independent table with Sum in Set analysis

Hi All,

I have 2 table which is not connected with any field. (Just for sample i mentioned 2 tables)

Now i need the Sum value based on the Table1 Dimension. see the below,

I tried with Concat(Distinct Table2.Sorg,',') in the set analysis.

       

                   Table1                   Table2
YearMonthSales OrgSales       YearMonthSorgSales
20150110002352015011000482
20150210003102015021000475
20150310008912015031000482
20150120006682015012000313
20150220007292015022000500
20150320009662015032000219
20150125001322015012500434
20150225004252015022500270
20150325009422015032500409
20150130007542015013000229
20150230001242015023000391
20150330002872015033000227

Expected output

Capture.123JPG.JPG

1 Reply
settu_periasamy
Master III
Master III
Author

Any Help on this?