topic Re: Listbox issue in QlikView

Listbox issue

udaya_kumar — Mon, 05 Nov 2012 15:53:00 GMT

Hi,

I have a listbox, user has to select it to see the tables and charts.

I have restricted the user in selecting only one value from the listbox.

I have selected one value in the QlikView Client, I published it to the server.

When i see the same file in the AccessPoint, multiple selection has happened for that listbox.

I dont know why it is happening like that.

can somebody help me?

Re: Listbox issue

Mon, 05 Nov 2012 16:14:02 GMT

In between developing on your client and publishing to the server, have you emptied the data model at all (perhaps to check in to source control). If you empty the data model (or you open without data) then these field level properties will be removed.

I get around this by applying a select trigger on opening the document then firing a macro to set the "One & only one" property value.

Re: Listbox issue

rajeshvaswani77 — Mon, 05 Nov 2012 16:17:08 GMT

Could be related to your plug-in. Test on both IE plug-in as well as AJAX plug-in to see if it works.

Re: Listbox issue

Mon, 05 Nov 2012 16:17:10 GMT

May sound strange but did you remember to save?

If you did, have you reloaded the document and did it fail once?

Re: Listbox issue

udaya_kumar — Tue, 06 Nov 2012 14:23:26 GMT

Hi everyone,

Even in both Ajax and IE plugin, it shows the same thing.

multiple values are getting selected in the server.

Reload failed sometime back, but i refreshed it again, it ran well.

Re: Listbox issue

udaya_kumar — Tue, 06 Nov 2012 14:25:21 GMT

Hi Nigel,

I didnt empty the data model and i didnt open it without data.

It was working fine before, but suddenly i dont know what happened,

it is happening like this. Multiple values getting selected only in Server, but not in Client.

Re: Listbox issue

udaya_kumar — Wed, 07 Nov 2012 12:24:58 GMT

Hi,

The problem was that, I used the Subfield function in the trigger to limit the user in selecting multiple values.

Because of that, multiple values were getting selected in the server. I guess, trigger was not working properly in the server.

But how do i limit the user from selecting more than one value?

I should not use "always only one value selected".

Re: Listbox issue

Wed, 07 Nov 2012 12:44:08 GMT

Why would you not use "always only one value selected", this is what it

is for?

Re: Listbox issue

udaya_kumar — Wed, 07 Nov 2012 14:49:33 GMT

Hi Nigel,

I dont want it to use because the user has to select the value from the listbox.

At the beginning, all the listboxes will be empty. then user will select the value based on his view of seeing the data. so if i can't use always only one value selected.

Can we do it with expression?

Because of triggers, it gave me the problem so.

Re: Listbox issue

Wed, 07 Nov 2012 15:51:21 GMT

Well, as far as I know you can only run a check that will provide a

warning to the user that they can only select 1 value (if they have

selected more than one).

Other option:

Populate the list box

Use a trigger to select the "default" option

Run a macro that sets the property of the list box to one and only one

This will have issues also, in that you then cannot clear the value

because of the above property being set, but it might be worth a try to

see if re-populating the list box clears the property. Bear in mind that

in order to set the property of one and only one, you must have a value

selected already which is why I have said to select a default. If you

cannot select a default value in the list box then I'm afraid you're not

going to be able to do anything apart from issue a warning that more

than one value is selected.

Re: Listbox issue

alexpanjhc — Wed, 07 Nov 2012 16:07:17 GMT

if you have a chart associated with the listbox that you want to calculate, you want to add the restriction in the calculation condition under general tab.

something like count(distinct ([your fieldname])=1

I think that may solve your problem.

then in your help, you can say, only one selection is allowed.

HTH

Re: Listbox issue

udaya_kumar — Thu, 08 Nov 2012 07:18:50 GMT

Hi Alex,

Where i need to add this expression?

count(distinct ([your fieldname])=1

In the Listbox or Chart?

I want it for the listbox.

Re: Listbox issue

jagan — Thu, 08 Nov 2012 07:54:58 GMT

Hi Udaya,

PFA file.

Regards,

Jagan.

Re: Listbox issue

alexpanjhc — Thu, 08 Nov 2012 14:26:27 GMT

no sorry. it is only available in charts.

Re: Listbox issue

Anonymous — Tue, 05 Feb 2013 18:33:25 GMT

Jagan,

How you arrived this?

Rgds,

Nandha

Re: Listbox issue

Anonymous — Tue, 05 Feb 2013 19:53:35 GMT

I got the solution Jagan. We want to write a trigger right?

Re: Listbox issue

Wed, 22 May 2013 21:14:46 GMT

This worked perfectly! Thanks!