Always one Value Selected

cristian_av — Thu, 02 Feb 2017 18:58:51 GMT

I have a field called "Year" and I need it to always have a value selected (It has the year.. 2014,2015,201...). I also have another field called YearVolume, that also has years, but from data that is apart from the main model.

So I use "Year" in Sheet 1-4 and Year2 in Sheet 5.

When I change the Active Sheet, YearVolume takes the value of Year and vice versa.

The trouble is that I can't use the option "Always one Value Selected" because it doesn't unselects the field when I leave the Sheets that use it, so I end it up with Year and YearVolume selected with the same year. But as they are two field, they exclude everything.

I'm trying to emulate the "Always one Value Selected" with a trigger for the field. I set the trigger to "On any select" with the following value, without luck:

=if(GetSelectedCount(Periodo)=1,Periodo,'2016')

Any idea how to solve this?

Re: Always one Value Selected

vinieme12 — Thu, 02 Feb 2017 19:05:28 GMT

can you post a sample app?

When I change the Active Sheet, YearVolume takes the value of Year and vice versa.

How are are you doing this??

Re: Always one Value Selected

cristian_av — Thu, 02 Feb 2017 20:12:33 GMT

With triggers in Sheet 5!

Trigger:

Field: Year

Expression: =if(GetSelectedCount(Year2)>0,'("' & Concat(DISTINCT Replace(Year2,' ','?'), '"|"') & '")','')

topic Re: Always one Value Selected in QlikView

Always one Value Selected

Re: Always one Value Selected

Re: Always one Value Selected