topic Re: List box clear field issue in QlikView

List box clear field issue

Wed, 30 Apr 2014 08:23:54 GMT

Hello Everyone,

I have a issue on clearing the selected value in list box by clicking again on selected field.

Eg: If I select a value in 'Age' list box, it is not getting cleared if I click on it again.

This issue is because I used the expression in list box to show the values only for the selected country and 'country' list box has "Always one selected value enabled".

Note: I need the "Always one selected value enabled" enabled in country list box.

Please find the attached test.qvw for reference.

Could anyone please help me to clear the selected value in list box by selecting the same value again?

Thanks in advance,

Karthikeyan.

Re: List box clear field issue

MK_QSL — Wed, 30 Apr 2014 08:27:20 GMT

If you have always one value selected in one list box, other list boxes also reflected by the selection due to the data association.

Re: List box clear field issue

jagan — Wed, 30 Apr 2014 08:29:51 GMT

Hi,

Instead of using experssion in list box try like this

Select Age in List box, and then Select Hide Excluded option in General tab.

Regards,

Jagan.

Re: List box clear field issue

Wed, 30 Apr 2014 08:31:00 GMT

Thanks for your response.

Yes, you are correct. But if I have a button to clear the selection from the list box, it's working by clearing only list box value and without clearing the country field value, which is the operation I want.

But I don't want to have a button to clear the selected value of list box.

Re: List box clear field issue

Wed, 30 Apr 2014 08:32:40 GMT

The hide excluded option is already enabled.

Please refer my attached test.qvw

Re: List box clear field issue

vijetas42 — Wed, 30 Apr 2014 08:35:58 GMT

Hi,

Use expression in list box as =Aggr(Fieldname,FieldName)

Re: List box clear field issue

Wed, 30 Apr 2014 08:45:05 GMT

No Luck. Same thing happening.

I used expression Aggr(Age,Country)