topic Re: Trigger Actions for Two Fields in QlikView

Trigger Actions for Two Fields

Fri, 31 Jan 2014 19:39:55 GMT

Hi All,

My requirement is by default the year = current year and period = current period.

I have created two trigger actions.One for Year and the other one for Period.

Year is working but not period.Can anyone help me on this.

Re: Trigger Actions for Two Fields

Fri, 31 Jan 2014 19:42:18 GMT

Hi,

Do you have possibility to upload a sample?

Re: Trigger Actions for Two Fields

agilos_mla — Fri, 31 Jan 2014 19:42:21 GMT

Please attached a sample.

The issue is probably due to a date format, do you use select in Field Period, max(Period)?

Re: Trigger Actions for Two Fields

Anonymous — Fri, 31 Jan 2014 19:44:52 GMT

Would making a single concatenated field of Year & Period help ?

Re: Trigger Actions for Two Fields

Anonymous — Fri, 31 Jan 2014 19:47:40 GMT

What is "period" and how the action looks like?

Re: Trigger Actions for Two Fields

Clever_Anjos — Fri, 31 Jan 2014 19:56:58 GMT

Is your period field related to year?

If so, be carefull about your expression on second action

Re: Trigger Actions for Two Fields

Fri, 31 Jan 2014 19:58:35 GMT

Hi All,

Here is the attached sample file.Thanks in advance.

Re: Trigger Actions for Two Fields

Clever_Anjos — Fri, 31 Jan 2014 20:00:58 GMT

Try =MAXSTRING([Calendar Period])

Re: Trigger Actions for Two Fields

Fri, 31 Jan 2014 20:02:46 GMT

MAXSTRING([Calendar Period]) is not working.

Re: Trigger Actions for Two Fields

agilos_mla — Fri, 31 Jan 2014 20:06:54 GMT

Cast you Calendar Period in a dual :

Dual(

IF (FISCAL_PERIOD = 1,'P1',

IF (FISCAL_PERIOD=2,'P2',

IF (FISCAL_PERIOD = 3, 'P3',

IF (FISCAL_PERIOD = 4,'P4',

IF (FISCAL_PERIOD = 5,'P5',

IF (FISCAL_PERIOD = 6,'P6',

IF (FISCAL_PERIOD = 7,'P7',

IF (FISCAL_PERIOD = 8,'P8',

IF (FISCAL_PERIOD = 9,'P9',

IF (FISCAL_PERIOD = 10,'P10',

IF (FISCAL_PERIOD = 11,'P11',

IF (FISCAL_PERIOD = 12,'P12',

IF (FISCAL_PERIOD = 13, 'P13'))))))))))))), ((FISCAL_YEAR-1)*13) +FISCAL_PERIOD) AS 'Calendar Period'

then using Max([Calendar Period]) in a select in Field action should do the trick.

Re: Trigger Actions for Two Fields

agilos_mla — Fri, 31 Jan 2014 20:09:41 GMT

Make alos you script simple : use 'P'&FISCAL_PERIOD instead of you long IF statement

Re: Re: Trigger Actions for Two Fields

Clever_Anjos — Fri, 31 Jan 2014 20:09:46 GMT

Worked here into OnOpen trigger

PFA

Re: Trigger Actions for Two Fields

Anonymous — Fri, 31 Jan 2014 20:11:05 GMT

=only({<PeriodID={"$(=max(PeriodID))"}>} [Calendar Period])

Re: Trigger Actions for Two Fields

Anonymous — Fri, 31 Jan 2014 20:12:00 GMT

you missed "="