topic Re: List Box Selections in QlikView

List Box Selections

bharatkishore — Thu, 24 Mar 2016 07:16:23 GMT

Hi All,

I am having a list box which is having some ten fields. My requirement is whenever i open the qvw all the fields in the list box should be highlighted by default(check boxes selected). Can you please tell me how to do this.

Thanks,

Bharat

Re: List Box Selections

Chanty4u — Thu, 24 Mar 2016 07:17:57 GMT

simple..

select all the fields and create a book mark and apply book mark via triggers on open ...

it gives u exct

Re: List Box Selections

Chanty4u — Thu, 24 Mar 2016 07:20:54 GMT

PFA

sample

Re: List Box Selections

Anonymous — Thu, 24 Mar 2016 07:27:20 GMT

go to the document properties-->Triggers-->On open<Has Actions>-->Edit Action

apply save your document and open it again you will get output like below:

Re: List Box Selections

bharatkishore — Thu, 24 Mar 2016 07:27:59 GMT

Thanks Chanty..

Re: List Box Selections

jagan — Thu, 24 Mar 2016 07:38:26 GMT

Hi,

Or you can simply select all the values in the field and save it.

I think Select In Field Action with * is the best option, because whenever you get the new values you don't need to update anywhere, if you use bookmark you have to update it when there is new values.

Regards,

Jagan.

Re: List Box Selections

bharatkishore — Thu, 24 Mar 2016 08:13:02 GMT

Thanks a lot Jagan...

Re: List Box Selections

Chanty4u — Thu, 24 Mar 2016 08:14:25 GMT

No issues. cooool

Re: List Box Selections

bharatkishore — Thu, 24 Mar 2016 08:15:54 GMT

Can you please tell me the process of how to do.. Do i need to do with Triggers.. I have done with ur option but it is not working,,

Re: List Box Selections

jagan — Thu, 24 Mar 2016 08:25:38 GMT

Hi,

Try as suggested by SANDIPSATBHAI. It is the best one.

Regards,

Jagan.

Re: List Box Selections

Chanty4u — Thu, 24 Mar 2016 08:29:24 GMT

chk it other solution abve jagan mentioned.

Re: List Box Selections

jagan — Thu, 24 Mar 2016 08:31:54 GMT

Before applying my solution you have to remove the document triggers if any.

Regards,

Jagan.

Re: List Box Selections

bharatkishore — Thu, 24 Mar 2016 10:00:53 GMT

Thanks Chanty..

Re: List Box Selections

bharatkishore — Thu, 24 Mar 2016 10:01:09 GMT

Thanks a lot Jagan...

Re: List Box Selections

Chanty4u — Thu, 24 Mar 2016 10:02:36 GMT

Welcome... Bro....

Best

Chanty