topic Triggers for Master calendar in QlikView

Triggers for Master calendar

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

Hi,

I have two calendar with 6 fields in my script.

with two master calendars in two different sheets.

Steps I have done:

In sheet properties I have set if CDay is selected in Main sheet if I go to sheet 1 it must affect only Day field in sheet 1.

But for me it is affecting the Month and Year also like selected not showing as associated.

Requirement:

If I select CDay or CMonth or Cyear in Main sheet, I move to sheet 1 if CDay selected means Day field must be selected like wise month and year only it must be reflected.

and the vice versa if I select sheet 1 and move to Main sheet it must be reflected.

I have attached sample data and sample qvw file.

Can any one help me!!!

Re: Triggers for Master calendar

Anonymous — Tue, 11 Jul 2017 20:21:07 GMT

Change all your triggers.

Example:

Action: Select in Field

Field: Day

Search String: =if(GetSelectedCount(CDay)>0,'('&Concat(Distinct CDay,'|')&')')

FYI - You don't need a formula in your field name. But you do need an IF statement in your search string.

Modify for each field.

Re: Triggers for Master calendar

yoganantha321 — Tue, 11 Jul 2017 20:29:01 GMT

Hi wallo,

If i select only CDay in Main sheet, CMonth and Cyear associates with this showing but in Sheet 1

It is displaying as the month and year also been selected

but I need the output in the sheet 1 as shown below:

Re: Triggers for Master calendar

Anonymous — Tue, 11 Jul 2017 20:40:16 GMT

See attachment