Using triggers to select data in Alternate States

[#1]

Hi all,

This is my first post.

I am currently trying to select a data from the default state.

Eg DepartureDate 30/12/2015 and with this date find out what the Last last year comparison date is.

These last year comparison dates are set by the business and look as follows:

Once I have found the last last year comparison date in the default state I then want to use this date eg 30/12/2013 and use this for my departuredate in the alternate state I have called "alt" to fidn the sum(rev) for 30/12/2013. LLY_COM means last last year comparison date

To do this i have added the following triggers:

The string search has the following expression

='=LLY_COM=Aggr(NODISTINCT Only(total {<DepartureDate=P($::LLY_COM)>} LLY_COM), DepartureDate)'

The issue is that when I use the above trigger in the alternate state it doesn't select just one DepartureDate it selects them all...

Can someone please help, I think maybe the following expression is not the correct one:

='=LLY_COM=Aggr(NODISTINCT Only(total {<DepartureDate=P($::LLY_COM)>} LLY_COM), DepartureDate)'

although this whole method worked for LY_COM so using the last year comparison date......just not for last last year.

[sunny_talwar]

Have you tried using this may be?

='(' & Concat({$} Chr(34) & LLY_COM & Chr(34),  '|') & ')'

[#3]

Hi,

Thanks for replying.

I have placed that here:

and tried it like this also but still not working....

[sunny_talwar]

You don't need to add this -> =LLY_COM='(' & Concat({$} Chr(34) & LLY_COM & Chr(34),  '|') & ')'

Just use this search string -> ='(' & Concat({$} Chr(34) & LLY_COM & Chr(34),  '|') & ')'

[#5]

Ye i did that but still not working, am I using the right state?

[sunny_talwar]

Looks right, not sure what isn't right. Can you share a sample?

[#7]

How do I add a qvw?

[sunny_talwar]

Step 1:

Step 2: