topic Re: Button to select date range in QlikView

Button to select date range

Fri, 06 Dec 2013 18:04:30 GMT

I have a field ENTER_DATE and I would like a button that select all dates more then 30 days old.

Every time I work with dates I feel as though its a format issue but I can't seem to get it to work.

I created a button, select in field...

-field: ENTER_DATE

-search in string: <=(date(today()-30))

Re: Button to select date range

Anonymous — Fri, 06 Dec 2013 18:10:14 GMT

It may be a format issue. But first try this:

='<=' & date(today()-30)

Re: Button to select date range

Mon, 09 Dec 2013 13:14:56 GMT

Thanks for trying but that didn't seem to work either....

Re: Button to select date range

Anonymous — Mon, 09 Dec 2013 13:17:43 GMT

Works for me... Can you upload an example?

Re: Re: Button to select date range

Mon, 09 Dec 2013 13:31:52 GMT

This is a scaled down version of what I am working on. The dashboard has a multi date slider in it, however, our company is still fairly new to QlikView and we are facing some push back. We are being told that the slider is not intuitive and they want a button... hence my question!

Thanks for your help

Re: Re: Button to select date range

Anonymous — Mon, 09 Dec 2013 13:42:31 GMT

I see...

The mistake is in the field name. Don't use "=" sign

=[Enter Date]

It should be simple

[Enter Date]

or even simpler

Enter Date

Next, doesn't look like a problem but safe to do, make sure that the format of the date in action is the same as in the field:

='<=' & date(today()-30, 'MM/DD/YYYY')

Regards,

Michael

Re: Re: Button to select date range

Mon, 09 Dec 2013 13:46:35 GMT

Ahh Ha! I love simple solutions!

Thanks for taking the time to help me out!