Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator II
Creator II

Expressions not interacting with Master Calender

Hello

I was wondering if someone could kindly take a look at the following expression as at the present time the expression is not interacting with my master calender and the data remains static  when I try and interact with the calender

I have also noticed that the expression does NOT limit to the data_source specified

Any suggestions are most welcome

Time(Fractile({$<FactDateNum = {">=$(=v_Start_Date_ED)<=$(=v_End_Date_ED)"}>}{<data_source={'Main ED'}>}ED_Total_Wait,0.95)/1440, 'hh:mm')

Kind Regards

Helen


1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try:

Time(Fractile({$<FactDateNum = {">=$(=v_Start_Date_ED)<=$(=v_End_Date_ED)"}, data_source={'Main ED'}>}ED_Total_Wait,0.95)/1440, 'hh:mm')

View solution in original post

2 Replies
tresesco
MVP
MVP

Try:

Time(Fractile({$<FactDateNum = {">=$(=v_Start_Date_ED)<=$(=v_End_Date_ED)"}, data_source={'Main ED'}>}ED_Total_Wait,0.95)/1440, 'hh:mm')

View solution in original post

helen_pip
Creator II
Creator II
Author

Thanks again for the second time today

That day I mentioned earlier about getting nearer to mastering set analysis may not be far away, but it certainly is not today

Thanks so much for your help

Helen