Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jegadeesan
Creator
Creator

Sum up multiple values to till date using set analysis

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

5 Replies
Anil_Babu_Samineni

Try this from preceding load

Or use expression

Dim is date field

And expression is

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

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

jegadeesan
Creator
Creator
Author

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...

akash3191
Partner - Contributor III
Partner - Contributor III

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.

jegadeesan
Creator
Creator
Author

IE version 10