Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator II
Creator II

Fractile expression with 2 set anlaysis, not quite working

Hello

I have written a Fractile expression and I want to use 2 set analysis's within the expression

Could soneone kindly take a look at the syntex and let me know where I am going wrong with the expression?

 

Time(Fractile( {<data_source_breaches={'Eye ED'}{$<FactDateNum = {">=$(=v_Start_Date_ED)<=$(=v_End_Date_ED)"}>} [Total Wait],0.95)/1440, 'hh:mm')

Kind Regards

Helen

3 Replies
tresesco
MVP
MVP

Try:

=Time(Fractile( {<data_source_breaches={'Eye ED'}, FactDateNum = {">=$(=v_Start_Date_ED)<=$(=v_End_Date_ED)"}>} [Total Wait],0.95)/1440, 'hh:mm')

helen_pip
Creator II
Creator II
Author

Hello

Thank you very much for your reply.   However I am still returning Null values, although the expression is O.K

Thank you for your effort

Thanks

Helen


tresesco
MVP
MVP

Try to post your sample qvw.