How to calculate a expression in a table to show it's value in another table in Qlik or Sense?

[#1]

Hi,All.

  I have a question of this in Qlik or Sense .I load a table like this ,It shows a expression in the colum figure,

how to make it shows it's values like below and generate a new table .

Does it need a meature ?,Maybe, but I can't remember.

消息编辑者为：li dan

[Gysbert_Wassenaar]

You can use the Evaluate function in the script:

T2:

LOAD *, Evaluate(purgechar(figure,'=')) as Result;

LOAD * INLINE [

ID, figure

1, =3*3

2, =2*3

3, =1*4

]

;

[#3]

Thank you for your reply .I have tested ,the method evaluate can be used in the script ,but I want to find a method can be used in a table,please

[Gysbert_Wassenaar]

Well, just for kicks then. Here's one from the Silly Tricks Department. See attached qvw.

[#5]

Thanks for your reply , I tested and edited the question ,please look and help

[Gysbert_Wassenaar]

See this discussion: Expressions in Fields