topic Re: Sum up multiple values to till date using set analysis in QlikView

Sum up multiple values to till date using set analysis

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

Hi All,

Three different measure field to be summed up to till date where ever the Closed field flagged as '0'

Data example :

Date field Measure1 Measure2 Measure3 Closed

01/02/2016 1000 1000 1000 1

01/03/2016 1000 1000 1000 1

01/04/2016 1000 1000 1000 0

01/05/2016 1000 1000 1000 0

01/06/2016 1000 1000 1000 0

Regards,

Jegadeesan G

Re: Sum up multiple values to till date using set analysis

Anil_Babu_Samineni — Tue, 11 Oct 2016 15:59:43 GMT

Try this from preceding load

Or use expression

Dim is date field

And expression is

Sum({<date = {'<=' & '$(=len(closed)>=0)'}>} (measure1+measure2+measure3))

Re: Sum up multiple values to till date using set analysis

sunny_talwar — Tue, 11 Oct 2016 16:01:44 GMT

In terms of numbers, what is the expected output and also in what object?

Re: Sum up multiple values to till date using set analysis

jegadeesan — Wed, 12 Oct 2016 04:27:07 GMT

Hi Sunny,

Object is pie chart. I have to show share of Demand and Collection. Given above table is for Demand calculation. The table for collection calculation also same as Demand but I didnt give that here...

Re: Sum up multiple values to till date using set analysis

akash3191 — Wed, 12 Oct 2016 05:13:50 GMT

Hi Jegadeesan,

Assuming you have DateField as the dimension, Could you please try out below expression?

Sum({<Closed={'0'}, DateField={'<=$(=max(DateField))'}>} Measure1 + Measure2 + Measure3)

Hope this helps.

It would be great if you can share the qvw containing this issue. That will help me understand the problem in a better way.

Thank,

Akash.

Re: Sum up multiple values to till date using set analysis

jegadeesan — Thu, 13 Oct 2016 12:46:50 GMT

IE version 10