topic Re: always selected one value in QlikView

always selected one value

manoranjan_d — Fri, 15 Jul 2016 05:35:19 GMT

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.

Re: always selected one value

vikasmahajan — Fri, 15 Jul 2016 05:43:16 GMT

Step 1 . for Sheet1 Go Sheet Properties -> Trigger -> On Activate -> Select in Field -> Select Field -
>Give Search Value

Step 2 . for Sheet2 Go Sheet Properties -> Trigger -> On Activate -> Select in Field -> Select Field -

>Give Search Value

Hope this helps you

Vikas

Re: always selected one value

vikasmahajan — Fri, 15 Jul 2016 05:43:57 GMT

Re: always selected one value

manoranjan_d — Fri, 15 Jul 2016 06:03:53 GMT

this is not the correct one, bcoz when i m movig to sheet2 there is no dept dept list box.

Re: always selected one value

vikasmahajan — Fri, 15 Jul 2016 06:14:21 GMT

additional action also you can add in this box while leaving sheet clear -> Field -> Dept

Re: always selected one value

vikramv — Fri, 15 Jul 2016 06:14:34 GMT

Oops fort to attach the screenshot...

You have to write a macro as mentioned in the below link:

How to clear the Always One Selected Value ListBox Property - QlikView Blog, QlikView Videos and Tips at QlikShare

In the first sheet use the attached option of list box.

Then use this macro in same sheeet triggers OnLeave Sheet --> ACtions -- > Extrenal --> Run Macro as per link above

As an alternative , We can use Alternative states to achive this kind of functionality.

Like You have to keep all the objects of that particular sheet a particular alternative state and all other sheets in normal state..

Hope this helps !

Re: always selected one value

MindaugasBacius — Fri, 15 Jul 2016 06:16:43 GMT

In sheet2 use trigger Clear Field

Re: always selected one value

jayaseelan — Fri, 15 Jul 2016 06:30:30 GMT

Hi Manoranjan,

Hope this will help you.

Re: always selected one value

manidhana90 — Fri, 15 Jul 2016 06:43:03 GMT

Hi Manoranjan,

Try to use Alternate state for sheet1's objects,

Refer this, Alternate States selection in default chart

Re: always selected one value

manoranjan_d — Fri, 15 Jul 2016 07:13:03 GMT

but as per the requirement it should have only one value to be selected in the list box, not more than one

Re: always selected one value

manoranjan_d — Fri, 15 Jul 2016 07:16:57 GMT

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

Re: always selected one value

manoranjan_d — Fri, 15 Jul 2016 07:20:39 GMT

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

Re: always selected one value

vikasmahajan — Fri, 15 Jul 2016 07:25:35 GMT

Try this Demo

Vikas

Re: always selected one value

Fri, 15 Jul 2016 09:46:09 GMT

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

Re: always selected one value

Peter_Cammaert — Fri, 15 Jul 2016 11:18:28 GMT

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