topic Re: Interpret field values as formulas in QlikView

Interpret field values as formulas

googel84 — Thu, 16 Oct 2014 15:44:19 GMT

Hi there, is there a way to interpret the content of a field as a formula and execute it? I have a table whose third field contains formula expressions and I want to execute instead of simply showing them.

Look at the picture below.

I tried with $ expansion and fieldvalue but it does not work.

Re: Interpret field values as formulas

stigchel — Thu, 16 Oct 2014 16:07:35 GMT

$ expansion in an expression is only evaluated once for the whole chart, so this will only work when there is 1 valid formula. Take a look at the following thread, maybe it can help you.

Using formulas from excel in the straight table

Re: Interpret field values as formulas

googel84 — Fri, 17 Oct 2014 07:21:34 GMT

I found the solution (it's pretty similar to the one suggested in the post mentioned by Piet Hein van del Stigchel.

First of all, formulas must not start with "=" symbol; then, the pivot table expression can be set like this:

pick([RTA_FORMULE.RTA measure index],

$(=fieldvalue('RTA_FORMULE.RTA measure formula 2',1)),

$(=fieldvalue('RTA_FORMULE.RTA measure formula 2',2)),

$(=fieldvalue('RTA_FORMULE.RTA measure formula 2',3)),

$(=fieldvalue('RTA_FORMULE.RTA measure formula 2',4)),

$(=fieldvalue('RTA_FORMULE.RTA measure formula 2',5)),

...

)

Thanks

Re: Interpret field values as formulas

sakamsureshbabu — Fri, 17 Oct 2014 07:26:45 GMT

$ expansion in an expression is only evaluated once for the whole chart, so this will only work when there is 1 valid formula.

Re: Interpret field values as formulas

ivan_will — Wed, 20 May 2015 08:21:13 GMT

Hi Alberto, Could you please explain your solution in details, I have just tested it and seems I can not make it working!

I have similar fields in my db as your [RTA_FORMULE.RTA measure index] and [RTA_FORMULE.RTA measure formula 2] where:

[RTA_FORMULE.RTA measure index] is the row no

[RTA_FORMULE.RTA measure formula 2] is the formula

Thanks in advance! If possible could you upload a simple example! Tnx

Re: Interpret field values as formulas

Anonymous — Tue, 22 Mar 2016 16:49:23 GMT

Ivan, did you ever find an example file using this? Thanks in advance.