topic Re: How to use between condition in date field in QlikView

How to use between condition in date field

Anonymous — Mon, 16 Feb 2015 09:54:29 GMT

Hi,

How to use between condition in date field.

i want to select the dates from 01/01/2007 to 31/12/2007.Kindly help me how resolve this issue.

rubenmarin — Mon, 16 Feb 2015 09:59:11 GMT

Hi Sathiskumar, you can set a filter like:

>=01/01/2007<=31/12/2007

Anonymous — Mon, 16 Feb 2015 10:03:54 GMT

Thank For Your Information

Kindly explain me where we want set this filter.

because i've use below method

Create two new variables…

vStartDate and vEndDate

Now go to Settings – Document Properties – Triggers

Variable Event Triggers

Select vStartDate

OnChange Add Action

Add

Select in Field

Field = Your Date Field

Search String = ='>='&vStartDate & '<=' & vEndDate

Do the same for vEndDate

But is not working.Kindly help me.

AbhijitBansode — Mon, 16 Feb 2015 10:13:09 GMT

Check value of variable in text object.

If it is appearing as a number, then you have to use below:

='>=' & Date(vStartDate) & '<=' & Date(vEndDate)

Anonymous — Mon, 16 Feb 2015 10:17:56 GMT

No it is date format only.

I think onChange Event not trigger.

Kindly advise me.

rubenmarin — Mon, 16 Feb 2015 10:20:29 GMT

Hi Sathishkumar, anyway, can you try what Abhjit said?, it's very usual that Qv internally uses a different value format than the one you see.

Anonymous — Mon, 16 Feb 2015 10:27:04 GMT

I tried that method but it is not working.Any other idea.

rubenmarin — Mon, 16 Feb 2015 10:43:39 GMT

It's working for me, please check attachment and look what you have different