Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Select data between startdate to enddate in the same column

i have data

datevalue
1/1/201120
2/1/201140
3/1/201150
4/1/201160
5/1/201170
6/1/201180
7/1/201190
8/1/2011200
9/1/201110
...

i need to use 2 calendar object. there are startdate and enddate

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

What if I upload it here.....

Let me know if you can open it and if it is any help for you.

Dennis.

View solution in original post

6 Replies
Anonymous
Not applicable
Author

Take a look at this QV-file I uploaded a while ago : http://community.qlik.com/qlikviews/1054

Maybe it contains what you need.

Not applicable
Author

i cannot  get your file

it's

Unauthorized

Not applicable
Author

Try this:

=Sum({$<date= {'<=$(=Date(vMaxDate))>=$(=Date(vMinDate))'} >} value))

its_anandrjs
Champion III
Champion III

Hi,

See the attached sample file.

Let me know

HTH

Rgds

Anand

Not applicable
Author

Thank you for all your answer ^^

i will try ...

Anonymous
Not applicable
Author

What if I upload it here.....

Let me know if you can open it and if it is any help for you.

Dennis.