Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
manish_madan
Creator
Creator

List Box feature need

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

16 Replies
manish_madan
Creator
Creator
Author

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.

manish_madan
Creator
Creator
Author

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

Jason_Michaelides
Luminary Alumni
Luminary Alumni

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

View solution in original post

manish_madan
Creator
Creator
Author

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

manish_madan
Creator
Creator
Author

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

Jason_Michaelides
Luminary Alumni
Luminary Alumni

How about

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

Hope this helps,

Jason

vupen
Partner
Partner

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)))