Sum multiple time fields when meet specific value under a field

[s10157754]

Dear Qlikview Experts,

How to use set analysis to sum my 'Time1', 'Time2', 'Time3' and 'Time4' fields when my 'Type' field is equal = 'M' ?

Appreciate a lot for your help!

Best Regards

QianNing

[olivierrobin]

hello

you can use something like

sum(${<Type={'M'}>Time1+Time2....  )

or whatever grouping function depending on your needs

[keerthika]

Hi,

    Field Time1 is hh:mm or mm:ss?

[keerthika · Accepted solution]

Hi,

    you can try this expression , iam considering the all Time fields as hh:mm so iam used hh:mm in expression , if this field is mm:ss you can change according to that,

=sum({<Type={'M'}>}interval(Timestamp#(Time1,'hh:mm'))+interval(Timestamp#(Time2,'hh:mm'))

+interval(Timestamp#(Time3,'hh:mm'))+interval(Timestamp#(Time4,'hh:mm')))

and in number tab under chart properties select Time and use Format pattern as hh:mm if you consider time field as hh:mm

[qv_testing]

PFA,

[vishweshwarisun]

hi

try this expression:

=sum({<Type={'M'}>}Time1+Time2+Time3+Time4)

[s10157754]

Dear Keerthika,

All time fields are in mm:ss.

[s10157754]

Dear Keerthika B,

Thank you so much for your expression. It works like a charm! Have a nice day!

Best Regards

QianNing