Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Expression: how to look up values from other table (not connected via data model) ?

Hi all,

I am a bit frustated now, because I am facing a problem which I am quite sure I figured out some time ago and should be possible but somehow I cannot get the right expression right now ...

so as a start, I want to get values from another table using an expression, not the datamodel (lets say, those tables are not connected)

table1:

A value1
15
26
37
48

table2:

C value2
110
211
312
4

13

what I would like to get:

A value1
value2
15 10
26 11
37 12
4813

so far I got for value2

=aggr(sum({<A={$(=C)}>}D),A)

which only return the sum of all value2 for all IDs

I am assuming I am missing something simple, am I right?

thanks and the best,

alex

2 Replies
MVP & Luminary
MVP & Luminary

It's not really recommended to make calculations over not associated tables. Why not simply connect them directly within the datamodel - even if you need to load one of these tables twice and rename fields here and there to avoid synthetic keys and circular references it's better as to handle loosen tables within the gui.

- Marcus

Creator
Creator

Hi Marcus,

yeah, I know that is not recommended.

Unfortunately I am working on an app with really complex datamodel and need to get some information here and there, which will not work with this datamodel. also, connecting the tables will not work due to circular references etc ... I would like to avoid making changes to the datamodel, but seems that this is necessary

thanks for your reply.

alex