Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Date | Daily Performance | Cumulative Performance |
---|---|---|
01/01/2012 | 10 | 10 |
02/01/2012 | 15 | 25 |
03/01/2012 | 7 | 32 |
... | ||
30/01/2012 | 15 | 47 |
31/01/2012 | 10 | 57 |
01/02/2012 | 5 | 5 |
02/02/2012 | 10 | 15 |
03/02/2012 | 7 | 22 |
04/02/2012 | 9 | 31 |
Hello,
I am looking for some help with set analysis, I need to provide a Cumulative Performance column on performance data.
What I am trying to achieve is displayed above,
With the cumalative performance expression restarting at each month beginning.
Any help would be appreciated,
Thanks
Jeremy
hi check this example
Thanks for reply!
Unfortunatly, I need the straight table to reflect the 'Cumalative Performance' up to the date and including any date selected.
EG: If i selecte the date 30/01/2012
30/01/2012 | 15 | 47 |
The above will be returned.
Jeremy
Hi,
Calculating the cumulative values during LOAD might be helpful.
Pls. see the following post:
http://community.qlik.com/message/122935#122935
Pls. let me know if it is not clear, I can provide an example.
Regards,
Hi Jeremy,
Let try this way:
1. Load Data
[Data]:
LOAD * INLINE [
Date , Daily Performance
01-01-2012 , 10
02-01-2012 , 15
03-01-2012 , 7
30-01-2012 , 15
31-01-2012 , 10
01-02-2012 , 5
02-02-2012 , 10
03-02-2012 , 7
04-02-2012 , 9];
2. Create one variable (Settings ==> Variable Overview ==> Add)
vAccumulate = Sum({$<Date = {"<=$(=MAX(Date))"}>} [Daily Performance])
3. Create Pivot Table with
a. Dimension:
1. Date
2. Daily Performance
b. Expression:
1. =RangeSum(Above(Total Sum([Daily Performance]),0,RowNo(TOTAL))) and put IsNull(Date) in Conditional (Enable expression when user clear Date value)
2. =vAccumulate and put NOT IsNull(Date) in Conditional (Enable expression when user select Date value)
4. Play around your data and selection.
See the sample attached file.
Hope this help.
Regards,
Sokkorn