topic Re: Select value from customer listbox in QlikView

Select value from customer listbox

Anonymous — Fri, 19 May 2017 02:30:36 GMT

Hi gurus

i have a customer listbox let say

valuelist(1,2,3,4,5)

how to get the value from this customer listbox in text object ?

thanks

Re: Select value from customer listbox

marcus_sommer — Fri, 19 May 2017 04:36:55 GMT

If you have a real field you could get these values per concat() or getfieldselections() - by using such a calculated dimension without a connection to the datamodel I don't think it will be possible. Maybe if you elaborate it a bit more thereare other ways to reach your aim.

- Marcus

Re: Select value from customer listbox

Anonymous — Fri, 19 May 2017 08:56:51 GMT

Hi Marcus,

let say i have a listbox with express : Valuelist(1,2,3,4,5), then once user click on 1, then

the pivot table will take this as a parameter , so the table express will

10 * <Value select from the listbox>

Can do it without load script ??

Thank you for your help

Re: Select value from customer listbox

marcus_sommer — Fri, 19 May 2017 09:15:27 GMT

If you instead of the valuelist() takes the content of a small inline table for the listbox, like:

load * inline [

];

you could easily refer to those selections, for example:

sum({< F1 = p(F2) >} AnyValue)

Another approach would be to use a variable within an inputbox (maybe with predefined values in a dropdown) to which your pivot could refer - but to a valuelist() I don't know any way.

- Marcus