Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
qliklizzy
Creator II
Creator II

help expression

Hi

Could someone help with this - it works - but i need it to calculate the percentage of MinAnaesthetistStart times that started within 10 minutes of the MinSessionStart but include all those that started before the MinSessionStart? 

sum({<OperationOrder={1},MinAnaesthetistStart ={"<>''"}>}  {<CancelledOnDay={0}>}

    
if( frac(MinAnaesthetistStart) <  (frac(MinSessionStart) + interval#('0:10','h:mm')),1,0))/

count(DISTINCT{<SessionUsed={1}>}  SessionID)

0 Replies