topic Re: Re: List Box issue in QlikView

List Box issue

krishna20 — Tue, 15 Jul 2014 10:17:04 GMT

Hi Friends,

How to show the values that has selected in two or more list boxes.If i select a value in one list box and the same color will be assign to the selected values in other list boxes.I mean the selected values to be highlighted by checking green color automatically.

Can anyone please suggest me how to do it.

Regards

Krishna

Re: List Box issue

jsingh71 — Tue, 15 Jul 2014 10:26:10 GMT

In what basis you want to select values in list box.?.please share some sample data and explain your requirement accordingly.

Then definately you will get answer.

--Jai

Re: List Box issue

Gysbert_Wassenaar — Tue, 15 Jul 2014 10:29:39 GMT

Not a good idea. Users won't be able to distinguish any more between values that were really selected and values in other fields that are not selected, but are the 'possible' values resulting from the selections they did make.

Re: List Box issue

amit_saini — Tue, 15 Jul 2014 10:30:48 GMT

Kalyan,

Instead of using list box you can use current selection box to see all the selections.

Thanks,

Re: List Box issue

Tue, 15 Jul 2014 10:31:05 GMT

Hi Krishna

Not sure what your problem is?!

If you want to get an overview on all selections that have been made, implement a "current selections" status box that is individually available.

However QV is an associative reporting tool, meaning when you do a selection on 1 field it will show you all the corresponding values of other fields -> something like: "this still belongs to your filter"

jsingh71 is correct. Without a sample QVW it will be difficult to answer based on your comment.

brgds,

Anthony

Re: Re: List Box issue

krishna20 — Tue, 15 Jul 2014 10:52:22 GMT

Hi Anthony,

Please find the attachment,in this i have marked the checkbox of listbox it should be shown in green color automatically.If i select a value in one list box.

Regards

krishna

Re: List Box issue

krishna20 — Tue, 15 Jul 2014 15:06:00 GMT

Hi Gysbert,

Your are right.But,my Client needs like that.So please suggest how can i get it.

Regards

krishna

Re: List Box issue

sudeepkm — Tue, 15 Jul 2014 15:22:36 GMT

if this is possible then it will contradict the QlikView's color code for selected and possible values in a field.

It seems your clients are trying to see the Possible values in Green color.

Re: List Box issue

krishna20 — Tue, 15 Jul 2014 15:24:46 GMT

Hi Sudeep,

Yes You are right.

Regards

Krishna

Re: List Box issue

Wed, 16 Jul 2014 05:57:14 GMT

Hi Krishna

Maybe you try this:

Go to document properties -> overview -> selection -> colour coding

There you may switch to user defined and give the color you want to assign...

Not sure if this is what you want?!?!

regards,

Anthony

Re: Re: List Box issue

krishna20 — Wed, 16 Jul 2014 06:17:12 GMT

Hi Anthony,

Thank you for your reply.Please find the attachment .You will understand what i need.In this i have selected the company,Possible values are showing normally.I need to show that the possible values also shown as to be selected by selecting check boxes.

Regards

Krishna

Re: List Box issue

Wed, 16 Jul 2014 07:47:05 GMT

Hi Krishna

I think you can only change it with my solution and a macro:

Got to Settings -> Document properties -> general -> color scheme and choose [custom] in it.

Like my image before...

Then you go to Document properties -> Triggers

add to "onOpen":

action: external -> Run macro

-> Name the macro and use the following code:

sub [Enter the macro name]

set up = acticedocument.getapplication.getuserpreferencesup.customselbgcolor(1).PrimaryCol.Col = RGB (X,Y,Z) //<- your preferred color --//

SecondaryCol.Col = RGB (A,B,C) //<- second color //

ActiveDocument.GetApplication.SetUserpreferences up

end sub

I think this is the only way to change the QV default color scheme but i am not sure if this works and if this workaround is what you are looking for...

regards,

Anthony

Re: List Box issue

Wed, 16 Jul 2014 07:49:19 GMT

Please see also the following thread with a similar issue:

Re: Change colour of selected (active) field

I hope this is useful for you.

Best solution however would be the explain your users the function of qlikview and make them accept the color scheme...depending your diplomatic skills...

Kind regards,

Anthony

Re: List Box issue

sudeepkm — Wed, 16 Jul 2014 09:14:30 GMT

Another suggestion would be to enable hide excluded values. In that case your clients will only be able to see the possible values in the list box.

I think you might have already explained it to them. I can understand your situation sometimes clients just sit on one requirement without giving an opportunity to consider if the tool has a default behavior.

Re: List Box issue

Wed, 16 Jul 2014 09:28:40 GMT

Hi Sudeep,

Even i am following this to know how would it work.For me its a limitation however when i was searching i got this from community:

Turning on the "Hide excluded" option in a list box, does not really hide the excluded values, but it makes the excluded values grey and the list stays the same length resulting sometimes in extremely long empty lists.

When this option is ticked, then the list should actually be reduced to the not-excluded values.

So i think its a limitation with QV.

Thanks

Re: Re: List Box issue

sudeepkm — Wed, 16 Jul 2014 10:17:07 GMT

yes you are right.

But this can be achieved. I've attached an example for your reference.

In the screenshot you can see the same list box one with expression and another with the field name which shows the excluded ones.

Re: Re: List Box issue

Thu, 17 Jul 2014 05:03:26 GMT

Hi Sudeep,

Thank you for sharing this,i will definitely try the same.