topic time diff in QlikView https://community.qlik.com/t5/QlikView/time-diff/m-p/1254586#M860547 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have attached the sample data.</P><P>the sheet has raw data and also required format</P><P></P><P>required is the summary level data. in the summary, i need to exclude vehicle id =CSD</P><P>also, i have to take the minimum of the vehicletime if i have multiple vehicles per single product number.</P><P></P><P>for eg. if i select product number 1611010010, then my percentiles should display 01:38:26.</P><P></P><P>How can i do this.</P><P>can someone please help me with the expression.</P><P></P><P>my current expression is </P><P><STRONG>INTERVAL(Fractile({&lt;[vehicle id]-={'*CSD*'}&gt;}(vehicletime-timeconnect),0.50))</STRONG></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z time diff https://community.qlik.com/t5/QlikView/time-diff/m-p/1254586#M860547 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have attached the sample data.</P><P>the sheet has raw data and also required format</P><P></P><P>required is the summary level data. in the summary, i need to exclude vehicle id =CSD</P><P>also, i have to take the minimum of the vehicletime if i have multiple vehicles per single product number.</P><P></P><P>for eg. if i select product number 1611010010, then my percentiles should display 01:38:26.</P><P></P><P>How can i do this.</P><P>can someone please help me with the expression.</P><P></P><P>my current expression is </P><P><STRONG>INTERVAL(Fractile({&lt;[vehicle id]-={'*CSD*'}&gt;}(vehicletime-timeconnect),0.50))</STRONG></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/time-diff/m-p/1254586#M860547 2020-11-25T16:16:04Z