topic sub Sum in QlikView

sub Sum

master_student — Wed, 06 Sep 2017 09:40:48 GMT

Hello Guys,

I hope everything is okay

I have a table that contains a few dimensions and an expression :

I need to get the Total of SLA inter BY groupe prestataire knowing that the SLA INTER IS a calculated dimension =Interval(Interval#(SLA_INTERM, 's'), 'm')

Re: sub Sum

Kushal_Chawda — Wed, 06 Sep 2017 11:28:43 GMT

Instead calculated dimension for SLA INTER create expression

=sum(aggr(Interval(Interval#(SLA_INTERM, 's'), 'm'),[Code Cas],[Date de commande],[SLA globale],[groupe prestataire]))

=sum(Interval(Interval#(SLA_INTERM, 's'), 'm'))

Re: sub Sum

sunny_talwar — Wed, 06 Sep 2017 11:36:05 GMT

Are you saying that for these rows

you would want to see 10635 on each of the rows?

May be this

=Interval(Sum(TOTAL <[Code Cas], [Date de commande], [SLA Globale], [Groupe prestataires]> Interval#(SLA_INTERM, 's')), 'm')

Re: sub Sum

its_anandrjs — Wed, 06 Sep 2017 11:47:47 GMT

What is the expected output you need also which fields are calculated dim.