Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
as sample , I write sum({<dealdate={">=$(=date(INDATE))<=$(=date($(E)+40))"}>} qty), the indate is a fields . I can't get right answer for different indate
Hi,
Its not possible to get the different date for each record in set analysis.
You will have to think about some other logic to achieve this.
Regards,
Kaushik Solanki
Hi,
Try this.
sum({<dealdate={">=$(=date(min(INDATE)))<=$(=date($(E)+40))"}>} qty)
Regards,
Kaushik Solanki
Try to remove equal sign
Sum({<dealdate={">=$(date(INDATE)) <=$(date($(E)+40))"}>} qty)
the problem is that the three row is the same value 2014/01/01, It is three value
I cann't work
Dear Jack,
Kindly explain in Detail, if possible with exmaple
Regards,
Kaushik Solanki
I have attached a sample.qvw . I want to get sum for different indate
Dear Jack,
Apologies, but i am still not getting what you are looking for.
Regards,
Kaushik Solanki
COMPANY | ITEM | INDATE | sum({<dealdate={">=-<=2014/3/13"}>} qty) |
A | 11 | 2014/1/1 | 30 |
A | 12 | 2014/1/2 | 10 |
A | 13 | 2014/1/3 | 20 |
B | 12 | 2014/1/2 | 20 |
B | 15 | 2014/1/5 | 0 |
B | 17 | 2014/1/7 | 0 |
B | 21 | 2014/1/1 | 0 |
C | 14 | 2014/1/4 | 20 |
C | 16 | 2014/1/6 | 30 |
C | 18 | 2014/1/8 | 0 |
C | 19 | 2014/1/9 | 0 |
this is a sample results . for COMANY A & ITEM 11 --- I should sum qty from 2014/1/1--- 2014/03/13 , for A&12 I sum from 2014/1/2--- 2014/03/13,
etc . If use min as you suggest , all company &item sum qty from 2014/1/1--2014/03/13
Hi,
So in short you need cumulative values?
Regards,
Kaushik Solanki