Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
dennisnet
Valued Contributor III

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

What if I upload it here.....

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

Dennis.

6 Replies
dennisnet
Valued Contributor III

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

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

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

i cannot  get your file

it's

Unauthorized

Not applicable

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

Try this:

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

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

Hi,

See the attached sample file.

Let me know

HTH

Rgds

Anand

Not applicable

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

Thank you for all your answer ^^

i will try ...

dennisnet
Valued Contributor III

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

What if I upload it here.....

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

Dennis.

Community Browser