Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Can any one help out me to create one user defined value in list box?

Hi Friends,

I have country field in listbox with country names as below.

Country

uk

india

australia

hongkong

canada

I have a scenario to create a field value "All" along with country names in list box as below.

Country

All

uk

india

australia

hongkong

canada

Atlast I need to get the complete data related to all countries when i click on "All" field value.

Please help on this.

This is much Appreciated.

Thanks,

Raju

Tags (1)
4 Replies

Re: Can any one help out me to create one user defined value in list box?

If you select no countries in the List Box then all countries will be displayed.

On the Caption tab of the List Box you could tick the Special icon for Clear and then the eraser will appear in the caption and you can click to get all countries.

Not applicable

Re: Can any one help out me to create one user defined value in list box?

Super Markham! I am thinking in very complicated way.


Anyhow we are looking to implement to get as field value in listbox as our client requested to get as field in country.

Thanks,

Raju

MVP
MVP

Re: Can any one help out me to create one user defined value in list box?

maybe adding a new field, NewCountry and using that as a listbox

a:

load

  distinct

  Country,

  Country as NewCountry

Resident ........;

load

  distinct

  Country,

  'ALL' as NewCountry

Resident ........;

IMHO is better to use the Special Icon "Select All"

Not applicable

Re: Can any one help out me to create one user defined value in list box?

Much Better!

Community Browser