topic Re: How to sum the value for specific date range? in QlikView

How to sum the value for specific date range?

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

Hello Anyone;

I am attempting to get values sorted by payment type for a range per the chart below.

I am not sure if i should be using a set analysis or not. Below is the function i am using to try and get transactions from 0 - 2500, however I keep getting nothing back. 2501 to 10000 is just a sum([Amt Paid]). Can anyone point me in the right direction?

Thank you in advance for any assistance.

=If([Amt Paid] >= 0 and [Amt Paid] <= 2500, sum([Amt Paid]))

Re: How to sum the value for specific date range?

Digvijay_Singh — Tue, 01 May 2018 16:07:58 GMT

May be this -

Sum({<[Amt Paid] ={">0<2500"}>}[Amt Paid])

Re: How to sum the value for specific date range?

Anonymous — Tue, 01 May 2018 16:10:44 GMT

Thank you!!!!!!!!!!!!!!!

Is this a set analysis?

Re: How to sum the value for specific date range?

Digvijay_Singh — Tue, 01 May 2018 16:14:14 GMT

Yes!