topic Expression not interacting with Master Calender in QlikView

Expression not interacting with Master Calender

helen_pip — Mon, 23 Jun 2014 10:12:00 GMT

Hello

I have an expression which is not interacting with my master calender

The part of the expression which needs to interact with the master calender is here:

{$<FactDateNum ={">=$(=v_Start_Date_18_Wks_Admitted)<=$(=v_End_Date_18_Wks_Admitted)"}>}

and the entire expression is:

=count({$<FactDateNum ={">=$(=v_Start_Date_18_Wks_Admitted)<=$(=v_End_Date_18_Wks_Admitted)"}>}
{<[18_Wks_Admitted_RTT_Return_Wait_Band_Adjusted]={'53 52 plus'}>}
[18_Wks_Admitted_RTT_Return_Wait_Band_Adjusted])

At the present time, my expression shows all of the count, and does not change when I change the values on the master calender

Any help would be greatly appreciated

Thanks

Helen

Re: Expression not interacting with Master Calender

alexandros17 — Mon, 23 Jun 2014 10:17:43 GMT

The correct sysntax is this:

=count({$<FactDateNum ={">=$(=v_Start_Date_18_Wks_Admitted)<=$(=v_End_Date_18_Wks_Admitted)"},
[18_Wks_Admitted_RTT_Return_Wait_Band_Adjusted]={'53 52 plus'}>}
[18_Wks_Admitted_RTT_Return_Wait_Band_Adjusted])

Let me know

Re: Expression not interacting with Master Calender

helen_pip — Mon, 23 Jun 2014 10:25:38 GMT

Thanks for your help

This is now interacting with my master calender

Thanks

Helen