topic Re: Alternate state & Trigger in QlikView

Alternate state & Trigger

woshua5550 — Wed, 25 Nov 2020 16:16:04 GMT

Hello Community

I have four list boxes, showing "Year" field with different anternate states

*This is precondition which means you can't charge it

I want to make a trigger event to achieve that when I click on "Year Overall" , "Year 1","Year 2","Year 3" should select the value as same as "Year Overall" selection automatically,but it shouldn't make any trigger if I select on "Year1" or "Year2" or "Year3".

for example

when I select 2015 on "Year Overall" , all the years should be 2015 , then I select 2016 on "Year1" , "Year1" should be 2016 and other years are still 2015

plz help , thx !

Re: Alternate state & Trigger

sunny_talwar — Thu, 22 Jun 2017 11:51:22 GMT

Check the attached

Re: Alternate state & Trigger

woshua5550 — Thu, 22 Jun 2017 12:28:52 GMT

Perfect !!!

May I ask what's the difference between "Concat({$1}Year)" and "Concat({$}Year)"

what's "Concat({$1}Year)" means?

Re: Alternate state & Trigger

sunny_talwar — Thu, 22 Jun 2017 12:31:55 GMT

Check Page 4 on the pdf attached here

Set Analysis: syntaxes, examples

$ is current selection

$1 is one previous selection

$2 is two previous selection

$_1 is one next selection

$_2 is two next selection

Re: Alternate state & Trigger

woshua5550 — Thu, 22 Jun 2017 12:45:12 GMT

Awesome ! Thanks for you help

Re: Alternate state & Trigger

VivenReddy — Wed, 22 May 2019 23:31:08 GMT

Great solution Sunny.

However this this not work in my solution where I am using a multi value slider object.

Are you able to assist with that?