topic Re: variables in list box in QlikView

variables in list box

Thu, 30 May 2013 16:46:42 GMT

Hi, I want to show variables in list box without loading them as inline or island table, is it possible? if yes, how?

thanks in advance.

jvitantonio — Thu, 30 May 2013 16:50:49 GMT

Yes, crete a list box, then in the field drop down, select <Expression> and enter your variable like

$(vVariable)

I hope this helps

Thu, 30 May 2013 19:17:23 GMT

my mistake, I mean all variables created in the app. Ex: if I have 5 Variables, wanted to show all variable names in the list box

Variable List

Var1

Var2

Var3

Var4

Var5

rustyfishbones — Thu, 30 May 2013 19:20:53 GMT

Have you tried an input box, why does it have to be a list box?

Thu, 30 May 2013 19:59:58 GMT

inputbox wont helps in my case, attached sample with what exactly I am looking for.

rustyfishbones — Thu, 30 May 2013 20:16:20 GMT

So you don't need to create variables do get adhoc reports

Create all your expressions and Conditionally show them based on a metric like this

Then create a Listbox using an expression using PICK() function

Thu, 30 May 2013 20:26:55 GMT

can you please upload a sample... how users get option to pick an expression from list box?

MayilVahanan — Thu, 30 May 2013 20:27:19 GMT

PFA

Use Valuelist function in listbox expression. but you can't select it.

Use inputField in script for edit the values. for ex: i used here state field like tat.