topic Re: Select Date Range By Month Year in QlikView

Select Date Range By Month Year

Wed, 16 Mar 2016 21:20:36 GMT

I am trying to select date range of Month Year values with alternate states , I already have an alternate state defined for my Tab , for some reason the Date range is not being selected in the Date field nor the Chart. And also please suggest if there is any other better way to do this instead of using alternate states.

Thank you

Re: Select Date Range By Month Year

robert_mika — Thu, 17 Mar 2016 04:12:50 GMT

Your Date range listbox has different state that rest of your objects so it will not pick up filters from Year or calendar.

Is this the issue you are facing?

Is the a reason to have every object in different state?

Re: Select Date Range By Month Year

settu_periasamy — Thu, 17 Mar 2016 05:39:31 GMT

Hi,

Instead of Select 'On Select' Trigger, try 'OnChange'

And change your search expression like

='>=' & Date(Date#(only({From}[Month]) &' '& only({From}[Year]),'MMM YYYY'))& '<=' &

Date(Date#(only({To}[Month]) &' '& only({To}[Year]),'MMM YYYY') )

Check the Attachment.

I suggest you to use Calendar Object / List box selection for From and To Date Instead on MultiBox. You can easily assign your value and retrive the date based on your range.

Re: Select Date Range By Month Year

jagan — Thu, 17 Mar 2016 05:47:10 GMT

Hi,

Check this link

Implementing From and To Date Selection using Calendar Objects

Regards,

Jagan.