Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Marius_
Contributor II
Contributor II

Aggr of the same field values in 2 different tables where the fields are not linked, but same values

Two tables are linked via site and contains the same field values. These to fields are not linked.

The idea is to summarize with aggregation the one table totals against the other table by using the field values that are the same in the two tables.

Aggregation on site (linked field) was successful but not with un-linked field

Please see Excel example and JPG for structure of model

 

2 Replies
sunny_talwar

May be create an island table for Group where you get all possible values from Table A and Table B and then use this

Sum(If(Group = TableAGroup, Value_A)

Sum(If(Group = TableBGroup, Value_B)

Brett_Bleess
Support (Former)
Support (Former)

I would also recommend reviewing the following Design Blog post, as it may be pertinent as well given your data model:

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.