Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
try this when you set your variables:
set vTienermoeders = "sum([Aantal tienermoeders])/sum({<Geslacht = {'Vrouwen'}>}[Vrouwen onder 18 jaar])";
regards,
MT
Hi
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 '|')
;
This inline load statement ran OK in QV 10SR5
Hope that helps
Jonathan
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!
Your expression should now be $(=Value) to evaluate the expression.
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
Yes, $Value is not $(=Value).
Sorry but I don't understand. I attached the latest version of the file.
Thanks for all your help
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)
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.