topic Re: Sumif based on field detail in QlikView

Sumif based on field detail

tinapullen1 — Fri, 20 Nov 2020 18:58:42 GMT

Hi,

I'm trying to write into script a formula to allow me to "sumif" fields based on the criteria. e.g. I have trip numbers that have many lines & each line has a pallet count. I would like a "results" field that adds up the pallet count based on the trip number. Example below - trip 1 has 2 lines of detail 1 being 5 plts, 1 being 2 plts. The result would be 7.

Trip Plts Result

1 5 7

1 2 7

Thanks in advance

Re: Sumif based on field detail

sergio0592 — Mon, 09 Nov 2020 13:54:43 GMT

Hi,

Try with

sum(TOTAL <Trip> Plts)

Re: Sumif based on field detail

tinapullen1 — Mon, 09 Nov 2020 14:05:27 GMT

Hi Sergio,

I can use this formula in the script?

Thanks

Re: Sumif based on field detail

Taoufiq_Zarra — Mon, 09 Nov 2020 14:10:55 GMT

@tinapullen1

Data: load * inline [ Trip,Plts 1,5 1,2 ]; left join load Trip ,sum(Plts) as Result resident Data group by Trip;