topic Re: Expression with 3 set analysis in QlikView

Expression with 3 set analysis

helen_pip — Tue, 29 Apr 2014 14:32:57 GMT

Hello

I have an expression which has 3 set analysis within it and but it is returning null values (When it shouldn't) and the expression is parsed as O.K.,with no error

Could someone kindly help me write the code correctly, so it will start returning values

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

[18_Wks_Admitted_RTT_Return_Wait_Band_Adjusted])

Any help would be very appreciated

Re: Expression with 3 set analysis

MK_QSL — Tue, 29 Apr 2014 14:39:53 GMT

count({<

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

Re: Expression with 3 set analysis

helen_pip — Tue, 29 Apr 2014 15:05:09 GMT

Hello

Thank you for your efforts, but the code is not working for me and I get a red error line just under the opening bracket just here:

FactDateNum= {

Any further suggestions would be greatly appreciated

Thanks

Helen

Re: Expression with 3 set analysis

MK_QSL — Tue, 29 Apr 2014 15:08:21 GMT

Try this... I missed a comma.

count({<

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

Re: Expression with 3 set analysis

tresB — Tue, 29 Apr 2014 15:13:00 GMT

Does your variable name '53 52 plus' really have single quotes? I guess they are causing your expression parsing not happen properly. You should try without them in the variable expansion.

Re: Expression with 3 set analysis

antoniotiman — Tue, 29 Apr 2014 15:13:26 GMT

Sorry Manish,

it is correct >} after ......plus')'} ?

Re: Expression with 3 set analysis

MK_QSL — Tue, 29 Apr 2014 15:16:03 GMT

count({<

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

count({<

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

Re: Expression with 3 set analysis

helen_pip — Wed, 30 Apr 2014 08:57:49 GMT

Hello

Can you kindly show me how with the original syntex

Kind Regards

Helen