2 Replies Latest reply: Oct 14, 2012 7:07 AM by yarosh_a

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?

• Re: How to map values in formula to another table

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

• Re: How to map values in formula to another table

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.