Formula/Variable in Load*Inline

[#1]

I want to load a formula (or variable containing a formula) in a load*inline.

As a simple example I got:

load * inline [

Variable_name, sum

x, sum({<ProdType={'PS-E'}>}ActQuantity)

y, 100

]

When I make a table box (or a graph) it does not return me the actual value for the sum just the text.

Any suggestions?

[Anonymous]

Jarl

I am pretty sure you need to use dollar expansion in the expression in your Chart Table.

For a test try putting the below in as the expression in a text object. 

               =$(=1+1)

I often find it best to test syntax in a simple text box. 

Do note the second = is needed.  If in the text object you remove this second = you will see that breaks it.

[#3]

Thanks all for your help! Got a big smile on my face, great way to start the long weekend. Got into Qlikview last week and it is challenging but I love it! The community is also great. Keep up the good work Bill, Sudheer, Felim and Jonathan.

[Anonymous]

Thank you for the compliment and for marking the helpful and correct answers for other members. Have a great weekend.

Sara