topic Re: Field Trigger not working like expected in QlikView

Field Trigger not working like expected

r_wroblewski — Fri, 10 Apr 2015 04:00:51 GMT

Hello Community

I created a field trigger which changed a field value(seperated table) according the selected period.

Action: Select in Field

Field: Period_Info

=if(Max(Date)=Max({1}Date) and Min(Date)=(Max({1}Date)-6), 'Last 7 days',

if(Max(Date)=Max({1}Date) and Min(Date)=(Max({1}Date)-29), 'Last 30 days',

if(Max(Date)=WeekEnd(Max({1}Date),-1) and Min(Date)=WeekStart(Max({1}Date),-1), 'Last Week',

if(Max(Date)=MonthEnd(Max({1}Date),-1) and Min(Date)=MonthStart(Max({1}Date),-1), 'Last Month',

'Individual'))))

For 'Last 7 days' & 'Last 30 days' the trigger works fine but for 'Last Week' & 'Last Month' the trigger select 'Individual'.

I checked the value in text boxes and they are correct and also tried with variables for 'Last Week'/'Last Month'. Same results.

Can someone advice me why the trigger is not working correctly ?

Best regards,

Ronny

ramoncova06 — Fri, 10 Apr 2015 04:37:54 GMT

Weekstart and monthstart are not rounded numbers

use a floor function before them

if(Max(Date)=floor(WeekEnd(Max({1}Date),-1)) and Min(Date)=floor(WeekStart(Max({1}Date),-1)), 'Last Week',

if(Max(Date)=floor(MonthEnd(Max({1}Date),-1)) and Min(Date)=floor(MonthStart(Max({1}Date),-1)), 'Last Month',

'Individual'))))

r_wroblewski — Fri, 10 Apr 2015 05:49:19 GMT

Dear Ramon,

Thanks for your advice.

It`s working fine now.

Regards

Ronny