topic Re: Evaluating expression out of a database string in QlikView

Evaluating expression out of a database string

Thu, 03 Oct 2013 11:50:52 GMT

Hi everyone

I have the following expression

=$(=2*2*3)

This returns, as expected, 12.

Now if I use

=$(='2*2*3')

it also returns 12,

In my dashboard I need to load this mathematical operation out of a database. Therefore I made a field named Formula in a database table. If I make the expression this way

=$(='Formula')

it returns, as exprected, the text "2*2*3". But I want to have it calculated.

Therefore I tried =$($(='Formula')) or =$(=$(='Formula')) but neither of them seems to work. Is there a way to solve this problem and to calculate the content of the Formula field?

Thanks in advance for any help.

Re: Evaluating expression out of a database string

tresB — Thu, 03 Oct 2013 11:56:47 GMT

Try:

=$(=Formula)

Re: Evaluating expression out of a database string

Thu, 03 Oct 2013 11:58:40 GMT

This doesn't resolve the expression at all.

Re: Evaluating expression out of a database string

Anonymous — Thu, 03 Oct 2013 11:59:52 GMT

Create the expression as a variable and call that variable in the expression

LET Var = '=$(='Formula')'

LET Var =$(='Formula')

and in the expression window use $(Var)

Re: Evaluating expression out of a database string

tresB — Thu, 03 Oct 2013 12:03:19 GMT

How are the values exactly in the field?

like: 2*2*3 , "2*2*3" or with single quotes?

Re: Evaluating expression out of a database string

Thu, 03 Oct 2013 12:05:19 GMT

In this way 2*2*3

Re: Evaluating expression out of a database string

Thu, 03 Oct 2013 12:12:50 GMT

unfortunately none of the both variants work. In the upper example LET Var = '=$(='Formula')' it is interpreted as a string, and the lower it has the same behaviour as in my code.

Re: Evaluating expression out of a database string

jerrysvensson — Thu, 03 Oct 2013 14:26:09 GMT

I don't know if I fully understood, but this works.

test:
LOAD * Inline [
Formula
2*2*3
];

Then add this expression to a textbox

=sum($(=Formula))

This will return 12