topic Re: Sum multiple time fields when meet specific value under a field in QlikView

Sum multiple time fields when meet specific value under a field

s10157754 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Sum multiple time fields when meet specific value under a field

olivierrobin — Thu, 26 Apr 2018 07:06:40 GMT

hello

you can use something like

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

or whatever grouping function depending on your needs

Re: Sum multiple time fields when meet specific value under a field

keerthika — Thu, 26 Apr 2018 07:23:18 GMT

Hi,

Field Time1 is hh:mm or mm:ss?

Re: Sum multiple time fields when meet specific value under a field

keerthika — Thu, 26 Apr 2018 07:28:18 GMT

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

Re: Sum multiple time fields when meet specific value under a field

Nagaraju_KCS — Thu, 26 Apr 2018 07:29:18 GMT

PFA,

Re: Sum multiple time fields when meet specific value under a field

vishweshwarisun — Thu, 26 Apr 2018 07:56:29 GMT

try this expression:

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

Re: Sum multiple time fields when meet specific value under a field

s10157754 — Thu, 26 Apr 2018 08:08:12 GMT

Dear Keerthika,

All time fields are in mm:ss.

Re: Sum multiple time fields when meet specific value under a field

s10157754 — Thu, 26 Apr 2018 08:22:24 GMT

Dear Keerthika B,

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

Best Regards

QianNing