topic Re: make group in listbox in QlikView

make group in listbox

arulsettu — Wed, 03 Jun 2015 03:55:16 GMT

Hi,

i am having country lsitbox like this

india

aus

what i need is

india

aus

group

if i select grouop it should select all countries

can anyone tell me how to do it?

Thanks

Re: make group in listbox

PrashantSangle — Wed, 03 Jun 2015 04:05:04 GMT

Hi,

Create Inline table or maintain mapping in Excel sheet

Like Load * INLINE[

Country, CountryGroup

india,India

us,US

uk,UK

aus,AUS

india,Group

us,Group

uk,Group

aus,Group

];

and link Country field with your Country Field and use CountryGroup as new Listbox

or You can also go with applymap()

Regards

Re: make group in listbox

arulsettu — Wed, 03 Jun 2015 04:07:04 GMT

Max

can you tell how to it with applymap

Re: make group in listbox

PrashantSangle — Wed, 03 Jun 2015 04:13:22 GMT

Hi,

In applymap case also you required inline table which maintain your country and mapField.

So better if you go with first suggestion.

For applymap I will get back to you with example.

Regards,

Re: make group in listbox

arulsettu — Wed, 03 Jun 2015 04:14:03 GMT

Re: make group in listbox

Siva_Sankar — Wed, 03 Jun 2015 05:37:53 GMT

Arul,

find the attached qv application. you need to create a trigger under document properties. Let me know if you need help in locating it.

Re: make group in listbox

Siva_Sankar — Wed, 03 Jun 2015 05:42:08 GMT

There is other way to achieve the same without trigger. find the attachment.

Re: make group in listbox

Wed, 03 Jun 2015 05:44:46 GMT

Your solution works perfect fine.Thanks Siva.

Re: make group in listbox

arulsettu — Wed, 03 Jun 2015 05:45:09 GMT

i will check siva

thanks

Re: make group in listbox

arulsettu — Wed, 03 Jun 2015 05:56:17 GMT

both solutions work fine.

thanks everyone.