topic Re: Calendar - Link List Box to Input Box in QlikView

Calendar - Link List Box to Input Box

Mon, 14 Jul 2014 20:36:54 GMT

Hi,

I am having an issue with setting up a calendar, have started off by linking an Input Box (which will house the selected dates) to a List Box (which housed my 'activity_date'), this works perfectly, when I type dates into the Input Box the appropriate dates are highlighted in the List Box.

Problem:

The problem I am having is that I cannot do the reverse. When I select one or more activity_dates these dates are not reflected in the input box as 'vStartDate' and 'vEndDate', I have followed the steps exactly in the very helpful video included below but cannot crack this small but essential link between the two.

Variables set up as: vStartDate and vEndDate

Event Trigger actions: OnChange - Select in Field

Field:activity_date

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

Field Event Triggers: OnSelect - Action Type = External, Action = Set Variable

Variable: vStartDate/vEndDate

Value: =Min(activity_date)/=Max(activity_date)

Am I missing something? Any help would be greatly appreciated.

Thanks very much

Re: Calendar - Link List Box to Input Box

Mon, 14 Jul 2014 20:54:47 GMT

Hi,

I just create 2 variables and Input Box, works fine with the qlikview natural behavior, see attached file.

I hope it will be that you need.

Best regards.

Re: Re: Calendar - Link List Box to Input Box

Mon, 14 Jul 2014 21:37:03 GMT

Hi Oswaldo,

Thanks for the quick response, your table seems to be working fine, I cannot find any difference between yours and mine, could you possibly take a look to see if you can spot anything that I may not have taken care of? I have attached my file.

Thanks