topic If only one value available, force its selection in QlikView

If only one value available, force its selection

Mon, 23 Feb 2015 08:00:31 GMT

Hi,

I have Section Access on a field which restricts some people to 1 value. If those people open on the dashboard I'd like to have this value autoselected in the field and stay selected for their session.

I know that if there's only one possible value, selecting it should not matter. But it does in my setup as it defines the consolidation level of my financial figures.

Re: If only one value available, force its selection

maxgro — Mon, 23 Feb 2015 21:28:13 GMT

try with 2 actions (at the sheet level, in trigger tab or at the document level, on open but maybe it doesn't work in ajax)

- select in field

yourfield

=yourfield

- lock field

yourfield

Re: If only one value available, force its selection

rwunderlich — Mon, 23 Feb 2015 22:08:49 GMT

In your logic that defines the consolidation, can you change from using GetSelectedCount()=1 to GetPossibleCount()=1?

-Rob

Re: If only one value available, force its selection

Tue, 24 Feb 2015 08:47:34 GMT

Hi Massimo,

onActivateSheet does not work in AJAX

I struggled to have a dynamic "select in field" for users who are not restricted, they should not have any value forced on them. So I came with OnAnySelect trigger

=if(count({1} distinct Field)=1,Field,GetFieldSelections(Field))

And a conditional Lock Field trigger as well since I don't want to lock for all access users.

That seems to work for me. Thanks for the suggestions of lock field.

Rob, I'm nog using any of the constructs.

Re: If only one value available, force its selection

maxgro — Tue, 24 Feb 2015 14:59:28 GMT

are you sure?

I tried with a small .qvw and for me it works (on ActivateSheet)

Server version 11.20.12235.0

Re: If only one value available, force its selection

rwunderlich — Wed, 25 Feb 2015 03:19:43 GMT

If you are not using GetSelectedCount or GetPossibleCount, then why does it matter if a single possible value is selected or not?

-Rob

Re: If only one value available, force its selection

Wed, 25 Feb 2015 06:29:45 GMT

It's like this: I have Turnover on consolidated group level, on country level, on entity level.

So I tag all my lines I read in with their level and I have a variable that checks the lowest selected grain and turns it into a level indicator (group, country of entity). So if they select a country, I show the country level lines. If they select nothing, I show consolidated group figures. The difficulty is that 2+2 is not 4 but more like 3,5 so I just read all those lines from SAP BPC and don't use the QV engine.

Now due to section access on country all lines for group level are deleted from the dataset (as they don't have a country) BUT as long as the users don't select a country, the level variable remains 'group' and thus empty gauges as a cause. So they have to select their own and only country to see country level lines.

I don't know if that's clear but it works as desired.

Re: If only one value available, force its selection

rwunderlich — Wed, 25 Feb 2015 17:37:33 GMT

What is the expression that sets the level indicator variable?

-Rob