topic Re: List box multiple default selections and Clear All in QlikView

List box multiple default selections and Clear All

Fri, 13 Feb 2015 00:06:54 GMT

Qlikviewers,

Let's say I have a list box with the following metrics:

Percent of ABC

Percent of MNO

Percent of XYZ

And I have a button for "clear all"

When a user logs in, Percent of ABC and Percent of MNO should be selected by default. And when a user hits Clear All the selections should go. and then when the user logs in to the Dash he/she should see the same two defaults. How can we make this happen?

Best!

Akshay

Re: List box multiple default selections and Clear All

Oleg_Troyansky — Fri, 13 Feb 2015 00:51:45 GMT

You could use Triggers and Actions to force these selection OnOpen, but these are sometimes flaky in the AJAX environment. I'd recommend to simply save the document with the two selections made, and that should always be the default when a user opens the document.

cheers,

Oleg Troyansky

www.masterssummit.com - take your QlikView skills to the next level!

Re: List box multiple default selections and Clear All

Fri, 13 Feb 2015 01:04:10 GMT

Hey Oleg! Thanks for your reply. Appreciate it. It's definitely something I didn't know but when I am toggling between sheets those selections are automatically clearing. I would want the selections to be there on both the sheets until I click clear all.

Re: List box multiple default selections and Clear All

jonathandienst — Fri, 13 Feb 2015 06:12:15 GMT

The selections should not clear when you move between sheets unless there is a sheet (de)activate trigger that is clearing selections, or a different alternate state set on the second sheet. Check sheet properties | triggers for the first, and look for alternate state settings in document properties | general | Alternate States...

HTH

Jonathan