topic Re: Total attribute from listbox in QlikView

Total attribute from listbox

psankepalli — Wed, 22 Jul 2015 19:42:38 GMT

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

Re: Total attribute from listbox

cspencer3 — Wed, 22 Jul 2015 20:33:23 GMT

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.

Re: Total attribute from listbox

sgrice — Thu, 23 Jul 2015 10:29:48 GMT

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

Basically if TOTAL ever select it should clear the others.

Re: Total attribute from listbox

sgrice — Thu, 23 Jul 2015 10:39:29 GMT

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.