topic Re: Using triggers to select data in Alternate States in QlikView

Using triggers to select data in Alternate States

Tue, 17 Nov 2015 17:08:30 GMT

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.

Re: Using triggers to select data in Alternate States

sunny_talwar — Tue, 17 Nov 2015 17:59:51 GMT

Have you tried using this may be?

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

Re: Using triggers to select data in Alternate States

Wed, 18 Nov 2015 15:59:55 GMT

Hi,

Thanks for replying.

I have placed that here:

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

Re: Using triggers to select data in Alternate States

sunny_talwar — Wed, 18 Nov 2015 16:03:51 GMT

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), '|') & ')'

Re: Using triggers to select data in Alternate States

Wed, 18 Nov 2015 16:09:02 GMT

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

Re: Using triggers to select data in Alternate States

sunny_talwar — Wed, 18 Nov 2015 16:13:19 GMT

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

Re: Using triggers to select data in Alternate States

Wed, 18 Nov 2015 16:25:02 GMT

How do I add a qvw?

Re: Using triggers to select data in Alternate States

sunny_talwar — Wed, 18 Nov 2015 16:51:46 GMT

Step 1:

Step 2: