topic Trigger issue in QlikView

Trigger issue

Anonymous — Wed, 11 Jun 2014 19:31:48 GMT

Hi guys,

I have calendar and field Campaign.

When I select any Campaign from field Campaign, my calendar finds first and last dates for selected Campaign and combine dates

oDate

='>=' &date(vStart,'DD/MMM/YYYY') & '<=' &date(vEnd,'DD/MMM/YYYY')

But when I deselect Campaign, oDate keeps selected period.

How to update oDate for whole period?

Please see my attached file.

Thanks,

Anonymous — Wed, 11 Jun 2014 20:09:51 GMT

Any ideas?

shawn-qv — Thu, 12 Jun 2014 05:45:28 GMT

Do you need to use triggers?

I'm guessing you can probably achieve what you want without having to set triggers, which can be much cleaner and simpler to manage.

But if you insist on using triggers, then you can add another set of actions to the OnChange field event for Campaign.

jagan — Thu, 12 Jun 2014 06:18:20 GMT

Hi,

Please find attached file for solution. I removed variable triggers and changed variables.

Regards,

Jagan.

Anonymous — Thu, 12 Jun 2014 15:44:00 GMT

Hi Jogan,

Thanks for your help.

The calendar stop working. When I select dates in calendar, it didn't combine in selected period.

But the main problem is deselect Campaign should automatically find the fist record and combine dates in oDate field.

Maybe for Trigger on Campaign wrong set up variables vStart and vEnd?!

The Campaign variable and calendar should works together.

If I select period in calendar, should work vStart and vEnd variables.

If I select Campaign, the calendar finds the first and the last days and use this period.

But when I deselect the Campaign, the calendar should show whole period and use whole period.

vStart and vEnd combine period in oDate field.

Thanks,