topic Re: Create a listbox with several variables in QlikView

Create a listbox with several variables

pauldamen — Fri, 16 Nov 2012 15:46:40 GMT

Dear all,

I want to create a listbox containing different variables I made which you can select.

So I have 5 variables created (5 formulas) which I want to put in a listbox so that users can select 1 which is then put into a graph.

How can I put the 5 variables in 1 listbox? I can't make a group because it is nog cyclic or drill down, I want to display the five variables just in a row.

How someone can help me!

Kind regards,

Paul

Re: Create a listbox with several variables

shree909 — Fri, 16 Nov 2012 15:50:42 GMT

Hi I am not sure but try like this.. goto the properties of listbox

when u create list box for one field ,when u scroll down the fieldnames u will find a option expression for listbox,

then use the necesssary formulas and create ur own list box..

Re: Create a listbox with several variables

whiteline — Fri, 16 Nov 2012 17:54:43 GMT

Hi.

Use inline sstatement in script to load your 5 formulas into one field. Then you could use this field in a listbox.

Re: Create a listbox with several variables

pauldamen — Mon, 19 Nov 2012 07:29:52 GMT

How can I make 5 formulas loaded into 1 field using an inline statement?

Re: Create a listbox with several variables

Mon, 19 Nov 2012 07:53:30 GMT

load * inline [

fieldname

value1

value2

value3

value4

value5

];

and then use fieldname for your listbox

regards,

Re: Create a listbox with several variables

pauldamen — Mon, 19 Nov 2012 13:37:00 GMT

Hi,

Is not working, it doesn't take the formula, the formula format looks like this:

sum([Betrokken bij echtscheiding <18])/sum([Jongeren onder 18 jaar])*1000;

But after the second bracket (before the next sum) it stops the formula, if have tried to put " around it but that doesn't help either.

Any ideas?

Regards,

Paul

Re: Create a listbox with several variables

whiteline — Mon, 19 Nov 2012 16:33:28 GMT

Two things: the quotes + dollar-sign expansion

Re: Create a listbox with several variables

pauldamen — Tue, 20 Nov 2012 08:09:14 GMT

Also with the quotes and the $ sign it doesn't work

Re: Create a listbox with several variables

Tue, 20 Nov 2012 08:18:16 GMT

Have you tried single quotes?

Re: Create a listbox with several variables

Tue, 20 Nov 2012 08:20:24 GMT

if you want to see the result have you tried to put a = at the beginning?

Re: Create a listbox with several variables

pauldamen — Tue, 20 Nov 2012 08:22:15 GMT

Yes also tried the single quotes, it always only wants to load the only the first part of the formula.

I have attached the file. I have now tried to put the variables under the second tab "bronnen" and the inline load is in the last tab "analyse"

Hope you can help

Re: Create a listbox with several variables

Tue, 20 Nov 2012 08:59:04 GMT

try this when you set your variables:

set vTienermoeders = "sum([Aantal tienermoeders])/sum({<Geslacht = {'Vrouwen'}>}[Vrouwen onder 18 jaar])";

regards,

Re: Create a listbox with several variables

jonathandienst — Tue, 20 Nov 2012 09:04:12 GMT

There are some undocumented features for inline loads. Here is an example that could work for you:

LOAD Key,
          Replace(Value, '#', '$') As Value
Inline
"
          Key| Value
          A| sum([Betrokken bij echtscheiding <18])/sum([Jongeren onder 18 jaar])*1000
          B| sum(#(vExpr)) / 1000
          C| sum(if(Flag = 3, 0, 1))
" (delimiter is '|')
;

The [ and ] have been replaced by double quotes (yes this is legal and it works) so your expressions can contain a closing ].
The comma separator has been changed to a pipe (|) so that your expressions can contain commas,
and the $() expansions have been suppressed by loading with a # in place of the $, and then replacing the # with a $ in the preceding load. This is so that the $ expansion is performed when the expression is evaluated in the front end and not in the script.

This inline load statement ran OK in QV 10SR5

Hope that helps

Jonathan

Re: Create a listbox with several variables

pauldamen — Tue, 20 Nov 2012 10:48:09 GMT

Great! Now I am able to load the formulas.

Next question; how can I use them in the table. The top table is the dynamic table which should show the value selected in the list.

The below table is an example what the second formula should look like if selected.

I attached a new file

Hope you can help!

Re: Create a listbox with several variables

Gysbert_Wassenaar — Tue, 20 Nov 2012 12:09:41 GMT

Your expression should now be $(=Value) to evaluate the expression.

Re: Create a listbox with several variables

pauldamen — Tue, 20 Nov 2012 12:29:28 GMT

As soon as I put a $ sign in front of the expression it turns it into a variable and doesn't recognize the field Value anymore

Re: Create a listbox with several variables

Gysbert_Wassenaar — Tue, 20 Nov 2012 12:33:26 GMT

Yes, $Value is not $(=Value).

Re: Create a listbox with several variables

pauldamen — Tue, 20 Nov 2012 12:42:01 GMT

Sorry but I don't understand. I attached the latest version of the file.

Thanks for all your help

Re: Create a listbox with several variables

Gysbert_Wassenaar — Tue, 20 Nov 2012 12:56:41 GMT

You changed your fieldname from Value to Variable. Since I can't read minds that means I still was working on the assumption that it was named Value. If you change the name of the field that means you'll have to change your expression too: $(=Variable)

Re: Create a listbox with several variables

pauldamen — Tue, 20 Nov 2012 12:59:47 GMT

Sorry I changed the name when testing something.

But still if I put variable it doesn't work, as soon as you put a $ sign and put brackets around it, it turns grey and makes it a variable not recongnizing the field.