topic Inputbox > choose items from field and put it in a variable in QlikView

Inputbox > choose items from field and put it in a variable

Thu, 16 Feb 2012 09:12:39 GMT

Hi,

I have a field [sales country name] and I want to do the following :

I'd like to have an input box with as constraint a predefined list of my [sales country name] field. Afterwards I want to use 2 of those input boxes to be able to compare salesdata of the chosen countries in specific charts.

I tried the following but it doesn't do the trick :

thanks for helping this newbie out!

Inputbox > choose items from field and put it in a variable

swuehl — Thu, 16 Feb 2012 09:23:34 GMT

I think there is a comma missing just before ',' in your concat, separating the two parameter in the function.

Re: Inputbox > choose items from field and put it in a variable

CELAMBARASAN — Thu, 16 Feb 2012 09:25:10 GMT

Hi,

Try with this expression

=Concat(Total Distinct [Sales Country Name],',')

Celambarasan

Re: Inputbox > choose items from field and put it in a variable

Thu, 16 Feb 2012 09:34:55 GMT

thanks, I didn't realise that there needed to be a comma in between, my mistake

it still doesn't work, when I open the dropdown I see a white block but with no data in. It seems like he wants to show something but he doesn't find any data, even though there are plenty of countries in:

Could I do possibly something else wrong as well, as in my settings for example? Or is the formula method to show things up not correct?

Thanks appreciate the prompt help, thumbs up

Inputbox > choose items from field and put it in a variable

swuehl — Thu, 16 Feb 2012 09:46:29 GMT

I think it should work. Have you tried copying the concat(...) expression into a textbox and check if your countries are listed appropriately?

Inputbox > choose items from field and put it in a variable

CELAMBARASAN — Thu, 16 Feb 2012 09:54:01 GMT

Hi,

If you click on drop down it will show the list of values.

Then if you need to display data without any selection in that drop down means..Use =MinString([Sales Country Name]) expression in value expression box which is under the settings for selected variable.

Hope it helps

Celambarasan