Total attribute from listbox

[psankepalli]

     Hello Experts,

I am working on QlikView application. I have few attributes coming from database.( abc, xyz, total) my requirement is when user selected Total from Listbox then he is not able to select abc, xyz. in same when user selects either abc or xyz total should grayed out. user have to lose the capability of selection total.

in other words, user can select either Total or abc, xyz alone, or abc and xyz. but not all three at a time.

palese suggest me the logic.

Thanks

San

[cspencer3]

I think the only thing like that is using the listbox property of 'Always One Value Selected', but this will allow you to select one and only one option. I don't think this function will work for you however.

[sgrice]

Yes you can do this with a onSelect trigger that changes the selection.

Basically if TOTAL ever select it should clear the others.

[sgrice]

in the Trigger OnSelect for Field Sel

Set the action to

Select in Field

Field

Sel

Value

=if(index(Concat(Sel,','),'TOTAL')>0,'(TOTAL)','('&Concat(Sel,'|')&')')

This code will default to TOTAL when CLEAR is pressed.