Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

woshua5550
Contributor III

Alternate state & Trigger

Hello Community

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

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

1.png

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 !

Tags (2)
1 Solution

Accepted Solutions

Re: Alternate state & Trigger

Check the attached

5 Replies

Re: Alternate state & Trigger

Check the attached

woshua5550
Contributor III

Re: Alternate state & Trigger

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

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

woshua5550
Contributor III

Re: Alternate state & Trigger

Awesome ! Thanks for you help

Highlighted
vivenreddy
New Contributor

Re: Alternate state & Trigger

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?