topic Re: Variable definition in Field in QlikView

Variable definition in Field

daniel_wennstro — Sat, 25 Jan 2014 15:23:24 GMT

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!

Re: Variable definition in Field

Sat, 25 Jan 2014 16:39:14 GMT

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

Re: Variable definition in Field

daniel_wennstro — Thu, 30 Jan 2014 10:10:32 GMT

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

Re: Variable definition in Field

Thu, 30 Jan 2014 10:44:11 GMT

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