How to display table with expressions of all variables in document

[stantrolav]

Hi!

I want to make some debug in my apps. I can show table of all variables in doc by using "Input Field" object. That table would show me two columns:

- Name of Variable

- calculated value of expression in Variable

But How to display expression that is in contents of Variables? I would better use chart wits some specific functions and expressions insted of macro.

[#2]

I would like to know the same...

Greetings,

Lucas

[Peter_Cammaert]

You cannot add expressions to input fields, there is just the name and the current value.

I got a solution using a Straight table but it isn't pretty. The problem is that text expansion using $(vVarName) happens before the object is filled, just like Set Analysis.

See the document that uses Pick(Match))

Good luck,

Peter

[ThornOfCrowns]

Ah, so you need to know the names of the variables first? I was hoping that there'd be a way of scraping that data dynamically.

[bgerchikov]

Hi.

You can use Input box. Just drug and drop all variables.

Another way is to export all the variables into spreadsheet using macro and load them back as a field.

Hope it helps.

[Peter_Cammaert]

There must be a method to list variables from their definitions using Macro's but I don't know if Macro's allow you to create or even add field/table content. Moverover, macro's may be a limiting factor for publication to the AccessPoint.

While it's not the most elegant soluton, the example works everywhere. I do hope that someone else posts a brighter view

[stantrolav]

There is now answer to my question. I think that thing must be like a new idea for QlikView NEXT.

[Anonymous]

hi,

Just add a new sheet object "Input box".

You'll see a list of available variables, add all variables then you'll have a table with the variable and their value (if it is an expression, you'll see it)

[Anonymous]

hi,

Just add a new sheet object "Input box".

You'll see a list of available variables, add all variables then you'll have a table with the variable and their value (if it is an expression, you'll see it)