always selected one value

[manoranjan_d]

Hi all

In sheet 1 i have list box of dept where that has to be always selected one value

now when i move to sheet 2 the always selected one value has to be cleared

how can we achieve this.

[manoranjan_d]

pls dont tell macro is an solution bcoz its perfromance issue , so not allowed

[manoranjan_d]

if i use alternate state then  in current selection we ll have the selected value of list box

[vikasmahajan]

Try this Demo

Vikas

[#5]

Hi Vikas,

Can you tell a solution for the same problem as raised by Manoranjan for qliksense server version?

It will be more helpful.

Thanks,

Keerthana

[Peter_Cammaert]

IMHO you cannot set/reset the Always one selected property of a field/listbox using triggers.

What you can do, and this is more in line with how QlikView should be used, is hide objects on Sheet 1 whenever more than Dept value is active. That will work in all cases, and in every client. And won't be too complex to implement.

You can even display a Calculation Condition text in all charts that instructs a user to select exactly one Dept value.

Best,

Peter