Variable definition in Field

[daniel_wennstro]

I would like to create a table containing several lines and columns, and with different expressions on each line.

For example:

Activity                        USD      

Development Cost      10 000        

Transportation              5 000         

License Costs            20 000       

And the expression for Development Cost should be based on a variable =vDevelopment

The Expression for Transportation should be based on variable =vTransport

The Expression for "License Cost" should be calculated from =vDevelopment*2

In order to do that i created an inline table containing:

LOAD * INLINE [

    Activity, USD, Notes

    Development Cost, =vDevelopment

    Transportation, =vTransport

    License Cost, =vDevelopment * 2

];

It works if i make $()-expansion in the load script, i will get the value as when the script was loaded, but i dont manage to make it dynamical as i can use a slider to change vDevelopment and update the table directly.

I want the variable name to be stored in the field and the expression in the chart to evaluate the variable content...

Please help me!

[#2]

Daniel,

May I suggest you to read the doc I have written on Dynamic Tables & Graphes:

http://community.qlik.com/docs/DOC-5733

It may be what you are looking for.

Fabrice

[daniel_wennstro]

Thank you Fabrice, but i did not find what i asked for in your document..

What i Want is to be able to put a variable name in a table and then in the variables put in different expressions, that makes it possible to use different expressions for different records without a lot of if-statements.

BR Daniel

[#4]

Daniel,

As far as I know, the $ expansion will evaluate once the content of the expression and will redirect to the appropriate one. In your case, you want for each line, redirect to the content of a different variable.

that is the same with Set Analysis: single evaluation.

I would say that it is impossible. But I hope for you that experts will say something else.

Fabrice