topic Re: Store possible values of listbox into different variables in QlikView

Store possible values of listbox into different variables

gauthamchilled — Wed, 20 May 2015 04:32:05 GMT

How can i store the pssoble values of listbox in different variables.

PFA,

I want the variables to use in a chart dynamically

Re: Store possible values of listbox into different variables

ToniKautto — Wed, 20 May 2015 04:44:29 GMT

The aggregation function will target your current data set, which include both selected values and possible values. A list box shows the values in a field, so by using Concat() you can concatenate all values in the field. For example =Concat(DISTINCT Month, ',') gives you a comma separated list of the filed values.

I am very unclear on why you want to store each value in separate variables. What is your use case with that?

You can pick a specific value from the list by using a function that allows indexes. For example =Max(Month) or =Max(Month, 1) returns the largest value, while =Max(Month, 3) gives the third largest.

Re: Store possible values of listbox into different variables

gauthamchilled — Wed, 20 May 2015 05:49:11 GMT

Toni,

Thanks for the reply. Max(Month,1) returns 3 here not the month name.

Re: Store possible values of listbox into different variables

gauthamchilled — Wed, 20 May 2015 05:51:34 GMT

i guess i have to use maxstring() but still Maxstring(field,1) not workin either

Re: Store possible values of listbox into different variables

tresB — Wed, 20 May 2015 05:56:02 GMT

For 3rd min value you can try like: =FirstSortedValue(Month, Aggr(Month,Month),3)