topic Need to add extra set analysis to existing Expression in QlikView

Need to add extra set analysis to existing Expression

helen_pip — Wed, 13 Aug 2014 09:48:07 GMT

Hello

I need to add some extra syntex to my already existing expression, but have been struggling for a few hours now to try and get it work

The first part of the expression is working O.K.

Here it is:

Time(Fractile({<data_source_group = State_1 :: data_source_group , FactDateNum = {">=$(=v_Start_Date_ED)<=$(=v_End_Date_ED)"}>} ED_Time_to_Triage ,0.95)/1440, 'hh:mm')

I now need to add in this extra bit of set analysis but am unsure where to place it......Can someone kindly let me

ED_Mode_Of_Arrival ={<'Ambulance','Helicopter'}>}

Any suggestions are greatly welcome

Kind Regards

Helen

Re: Need to add extra set analysis to existing Expression

tresB — Wed, 13 Aug 2014 09:54:03 GMT

Try like:

Time(Fractile({<ED_Mode_Of_Arrival ={'Ambulance','Helicopter'}, data_source_group = State_1 :: data_source_group , FactDateNum = {">=$(=v_Start_Date_ED)<=$(=v_End_Date_ED)"}>} ED_Time_to_Triage ,0.95)/1440, 'hh:mm')

Re: Need to add extra set analysis to existing Expression

helen_pip — Wed, 13 Aug 2014 09:57:45 GMT

Hello

Thank you so much! This works for me.....One day I will get the hang of set analysis

Kind Regards

Helen

Re: Need to add extra set analysis to existing Expression

tresB — Wed, 13 Aug 2014 09:59:34 GMT

And that day is not far away