minutes display

master_student — Thu, 09 Nov 2017 14:17:37 GMT

Hello

I have a field that diplays a measure in minutes

Here is the expression :

= Interval(Sum({<[Code Cas] = p({<[Statut Cas] = {'Fermé crédit', 'Fermé-remboursé', 'Fermé activation', 'Fermé BO', 'Fermé DT', 'Fermé Rétention', 'Fermé Rétention Client Perdu', 'Fermé Rétention Client Retenu'}>})>}TOTAL <[Code Cas], [Date création], [Statut Cas], PROVIDER_GRP_ID> Interval#(SLA_GLOBAL, 's')), 'm')

The result is :

Whene I export the table into Excel the result become like this : 02:35:42

Any idea, to keep it in minutes

Thanks a lot

Re: minutes display

sunny_talwar — Thu, 09 Nov 2017 14:26:44 GMT

Try this

Num#(Interval(Sum({<[Code Cas] = p({<[Statut Cas] = {'Fermé crédit', 'Fermé-remboursé', 'Fermé activation', 'Fermé BO', 'Fermé DT', 'Fermé Rétention', 'Fermé Rétention Client Perdu', 'Fermé Rétention Client Retenu'}>})>}TOTAL <[Code Cas], [Date création], [Statut Cas], PROVIDER_GRP_ID> Interval#(SLA_GLOBAL, 's')), 'm'))

topic minutes display in QlikView

minutes display

Re: minutes display