topic Re: Evaluate the expression which is located in table as a string. in QlikView

Evaluate the expression which is located in table as a string.

pavan045 — Fri, 25 Mar 2016 10:18:58 GMT

I have a table like below which consists of expressions as feild values.

I need those expressions in this table to get evaluted when i load them into a straight table.

Thank you

sunny_talwar — Fri, 25 Mar 2016 11:55:34 GMT

May be with a dollar sign expansion?

$(=Sheet_Name)

swuehl — Fri, 25 Mar 2016 12:06:05 GMT

This will only work with a single Sheet_Name as possible value.

If you want to create a table with dimension ID and using the appropriate expression per ID, I believe you need a pick() or pick(match()) solution:

Pick( ID,

Sum(Value),

Count(Value),

Avg(Value)

)

You can build this expression upfront as variable in the script using the table with ID and expressions and CONCAT() function.

edit: removed typo

petter — Fri, 25 Mar 2016 12:06:08 GMT

If you do this - you will keep the static strings as well:

If( Flag = 1 , $(=Sheet_Name) , Sheet_Name )

Peter_Cammaert — Fri, 25 Mar 2016 13:19:29 GMT

Or you could quote the simple text strings in your original table. Which IMHO is more consistent with your original expression-based set-up.

Peter_Cammaert — Fri, 25 Mar 2016 13:24:46 GMT

This document may be useful. A screnshot of the output (I added some data where needed).

In the future, please don't post example data as a screenshot. Nobody likes copying text from an image...

Best,

Peter

Peter_Cammaert — Fri, 25 Mar 2016 13:26:19 GMT

Actually and on second reading, this is just an illustration of Stefan's earlier explanation. Points should go to him.

MarcoWedel — Sun, 27 Mar 2016 21:17:28 GMT

Hi,

one example of Stefan's and Peter's solution in the front end only:

hope this helps

regards

Marco