topic Re: set a MTD range based on date selection in QlikView

set a MTD range based on date selection

Anonymous — Wed, 29 Jun 2016 19:58:21 GMT

Hello,

I'm having trouble creating a MTD button that selects the date range based on the date I select.

For instance, if I select 06/29/16, then click the MTD button, I want the date field to select the date range 06/01/16 - 06/29/16.

Any help is greatly appreciated.

Thank you!

Re: set a MTD range based on date selection

sunny_talwar — Wed, 29 Jun 2016 20:08:41 GMT

May be set the search string expression to be like this:

='>=' & Date(MonthStart(Max(DateField)), 'MM/DD/YY') & '<=' & Date(Max(DateField), 'MM/DD/YY')

Re: set a MTD range based on date selection

Anonymous — Wed, 29 Jun 2016 20:14:39 GMT

Thank you for the reply Sunny. I figured it was something like this, however, my button just seems to clear the date selection when I put this into my search string. I'm replacing DateField with my actual field and formatting it.

Re: set a MTD range based on date selection

sunny_talwar — Wed, 29 Jun 2016 20:16:12 GMT

Can you share the screen shot of your search string and also your datefield?

Re: set a MTD range based on date selection

Anonymous — Wed, 29 Jun 2016 20:25:01 GMT

Here's the date field I'm using and a screenshot of the search string

Re: set a MTD range based on date selection

sunny_talwar — Wed, 29 Jun 2016 20:28:39 GMT

Can you try to check after adding the Date field format?

='>=' & Date(MonthStart(Max(%D_PERD)), 'M/D/YY') & '<=' & Date(Max(%D_PERD), 'M/D/YY')

Re: set a MTD range based on date selection

Anonymous — Wed, 29 Jun 2016 20:36:26 GMT

No luck It's still clearing the date field whenever I select a date

Re: set a MTD range based on date selection

sunny_talwar — Wed, 29 Jun 2016 20:38:04 GMT

Do you have another action assigned to the button or a trigger on %D_PRED?

Re: set a MTD range based on date selection

Anonymous — Wed, 29 Jun 2016 20:43:55 GMT

I have no other action on the button and no triggers on %D_PERD

Re: set a MTD range based on date selection

sunny_talwar — Thu, 30 Jun 2016 00:11:11 GMT

Not sure what is wrong, would it be possible to share a sample?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample