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.