Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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 .

QQ图片20150504125821.png

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

消息编辑者为:li dan

5 Replies
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

]

;


talk is cheap, supply exceeds demand
Not applicable
Author

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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

Gysbert_Wassenaar

See this discussion: Expressions in Fields


talk is cheap, supply exceeds demand