topic Re: QlikView AccessPoint: How to select range of dates? in QlikView

QlikView AccessPoint: How to select range of dates?

Anonymous — Mon, 27 Nov 2017 04:30:54 GMT

Hi all,

I know we can press and hold CTRL + select specific dates or left click and drag. However, how do we do this if we want to write into the date input box, for example, 1/27/2017 to 1/30/2017?

Re: QlikView AccessPoint: How to select range of dates?

stabben23 — Mon, 27 Nov 2017 07:54:20 GMT

Hi,

You could use the magnifier and Write >=1/27/2017 <= 1/30/2017, then press enter. All valid Dates should then get "green".

Re: QlikView AccessPoint: How to select range of dates?

marcus_sommer — Mon, 27 Nov 2017 07:56:04 GMT

You could specify multiple values with a pipe-sign as delimiter, for example:

(1/27/2017|...|1/30/2017)

whereby in your case would be a search with operators more suitable, with something like:

>=1/27/2017<=1/30/2017

- Marcus