topic Re: List Box feature need in QlikView

List Box feature need

Anonymous — Thu, 12 Jun 2014 10:13:54 GMT

Hi,

I am looking for a functionality like when i click on the 1st option(in attached qvw) only then second should b activate but what is happening in my case those option which dimension objects which are not present for that selection are grading out but i can select those, i want they should appear but user will not be able to select those.

Thanks

Manish

Re: List Box feature need

vijetas42 — Thu, 12 Jun 2014 10:44:50 GMT

Hi,

I think,You can apply sheet visibility for your scenario where you can set sheet show visibility property on condition

Regards,

Vijeta

Re: List Box feature need

Anonymous — Thu, 12 Jun 2014 10:59:48 GMT

Actually if you see attached qvw in this if u make a selection on LL1 the next LAN gives a disable look but still m able to click on that what i want it should appear on sheet but click option should not work.

Thanks

Manish

Re: List Box feature need

vupen — Thu, 12 Jun 2014 11:00:28 GMT

I believe you want to go against the QV's basic feature of Associate Model.

You can have a separate table each for those fields and make sure that such tables are not connected to any other table. This way, selections made in those disconnected tables/fields do not impact objects.

Re: List Box feature need

jsingh71 — Thu, 12 Jun 2014 11:05:56 GMT

You need to replace your expressions in Layout tab under conditional box like this

1. GetSelectedCount([Compentancy Model]) > 0

2. GetSelectedCount(Zone)>0

and so on....

--Jai

Re: List Box feature need

Anonymous — Thu, 12 Jun 2014 11:18:28 GMT

=1 is for one selection, more than one selection is not allowed, so by anyhow if more than one selection happen it will retain functionality.

Re: List Box feature need

vupen — Thu, 12 Jun 2014 11:18:53 GMT

OK..as I see your second post,

Have a transparent text box on top of the subsequent list boxes and show/hide them conditionally using GetFieldSelections(prev list box field name) on the layout tab of the text box.

Re: List Box feature need

jsingh71 — Thu, 12 Jun 2014 11:21:43 GMT

In your case you allowed only user to select one value at a time so it will work perfectly.

Now if you have any other issue then let community know.

--Jai

Re: List Box feature need

Anonymous — Thu, 12 Jun 2014 11:25:19 GMT

yes,but when you click on grade out selection all above made selections disappear to avoid this i want to disable grade out selection.

Re: List Box feature need

vupen — Thu, 12 Jun 2014 11:30:42 GMT

Try Hide Excluded option on the General tab. Values that are not relevant for the current selections will be hidden in such list boxes.

Re: List Box feature need

Anonymous — Thu, 12 Jun 2014 11:34:10 GMT

That's a good idea...but as soon my data gets change...i am bit confuse if it works properly after that as well.

Hide exclude i tried it is as per requirement all values should b visible.

Re: List Box feature need

Anonymous — Thu, 12 Jun 2014 11:34:52 GMT

Hide exclude i tried, as per requirement all values should b visible.

Re: List Box feature need

Jason_Michaelides — Thu, 12 Jun 2014 11:54:22 GMT

In the properties of the top list box select "Override Locked Field". Then make a default selection (e.g. LL1) and lock the field.

Because this field is locked, you cannot make selections in other list boxes that go against the current selection in this field. However because you have set this field to "Override Locked Field" you can make new selections in this field without unlocking.

See attached - hope this helps,

Jason

Re: List Box feature need

Anonymous — Thu, 12 Jun 2014 14:44:32 GMT

Hi All,

Thank you so much for precious suggestions.

Finally Jason Idea i have implement and it worked as I wanted to be.

BR,

Manish

Re: List Box feature need

Anonymous — Thu, 12 Jun 2014 14:51:48 GMT

I have one quick question.

if i want to change the field values in listbox instead of script level,is it possible?

Example: i have 5 name in list box

1 Manish Madan

2 Ray bell

3 albin

4 joy

5 mike

I want to write(abbreviation type)

manish as MM

Ray bell as Rb

albin as a

joy as j

mike as m

Re: List Box feature need

Jason_Michaelides — Thu, 12 Jun 2014 15:03:38 GMT

How about

Left(SubField(Name,' ',1),1) & Left(SubField(Name,' ',2),1)

Hope this helps,

Jason

Re: List Box feature need

vupen — Thu, 12 Jun 2014 15:08:30 GMT

Instead of a field, choose Expression as base for the list box.

In the expression area, write a nested IF statement similar to the below code:

=If(EName='manish', 'MM',

If(EName='Ray bell','Rb',

If(EName='albin','a',EName)))