Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have data
| date | value |
|---|---|
| 1/1/2011 | 20 |
| 2/1/2011 | 40 |
| 3/1/2011 | 50 |
| 4/1/2011 | 60 |
| 5/1/2011 | 70 |
| 6/1/2011 | 80 |
| 7/1/2011 | 90 |
| 8/1/2011 | 200 |
| 9/1/2011 | 10 |
| ... |
i need to use 2 calendar object. there are startdate and enddate
What if I upload it here.....
Let me know if you can open it and if it is any help for you.
Dennis.
Take a look at this QV-file I uploaded a while ago : http://community.qlik.com/qlikviews/1054
Maybe it contains what you need.
i cannot get your file
it's
Try this:
=Sum({$<date= {'<=$(=Date(vMaxDate))>=$(=Date(vMinDate))'} >} value))
Hi,
See the attached sample file.
Let me know
HTH
Rgds
Anand
Thank you for all your answer ^^
i will try ...
What if I upload it here.....
Let me know if you can open it and if it is any help for you.
Dennis.