Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
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))

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

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
Partner

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

IE version 10