Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to map values in formula to another table

I`ve got two tables, one of them has a column which contains expressions like (A_B_C)/(D_E_F) and (A_B_C)*(D_E_F).

Another table contains columns A,B,C,D,E,F that should match those from expressions. Please tell me, what`s the best way for me to do this?

2 Replies
IAMDV
Luminary Alumni
Luminary Alumni

Hi,

Just wanted to make sure if I understood it correctly. You have two tables - one with expressions and another table with the actual numbers. And you wanted to use the expressions from first table. Is this right? Not sure how you wanted to use the expressions. Please can you provide more explanation?

Thanks,

DV

www.QlikShare.com

Not applicable
Author

Deepak, you are right, expressions in 1st table use actual numbers in second one (which is, actually, a crosstable).

As I said, expressions look like (A_B_C)/(D_E_F), where letters in expression (A_B_C) should match fields A and B in columns of the 2nd table, and C is a name of another column in 2nd table. Thus the actual number should be found.