topic Re: Variable as drop down list values in input box in QlikView

Variable as drop down list values in input box

Thu, 22 May 2014 01:28:01 GMT

Hi.

I want to have an input box with a predefined drop down list showing values, (e.g. Product1, Product2, Product3).

Entering: Product1;Product2;Product3 in the Contraints tab, listed values of the input box works.

i.e. We see:

Product1

Product2

Product3

However, I want this list to be dynamic, so I have stored the values in a variable vCurrentProductList.

When I have this: vCurrentProductList = 'Product1;Product2;Product3'

and I put =vCurrentProductList in the Inputbox Contraints, listed values - the drop down doesn't work. It shows them all in 1 line:

Product1;Product2;Product3.

How can I use the variable to get a result like this instead:

Product1

Product2

Product3

Thank you.

ashfaq_haseeb — Thu, 22 May 2014 06:31:49 GMT

Hi,

look at the attached.

Regards

ASHFAQ

Tue, 29 Sep 2015 14:07:44 GMT

Try using the following formula:

=Concat( {1} DISTINCT vCurrentProductList, ',' , vCurrentProductList)

It should list them in a column sorted ascending by vCurrentProductList. If the comma for the second parameter doesn't work, try a semicolon.

sabirguiri — Wed, 13 Mar 2019 15:49:48 GMT

Try this:

=Concat( {1} DISTINCT YearWeekNumber,'|',YearWeekNumber)

Replace the YearWeekNumber with your column header title name.