topic Re: Slider/Calendar Object Properties issue. in QlikView

Slider/Calendar Object Properties issue.

renuka_sasikumar — Wed, 24 Feb 2016 12:03:23 GMT

Hi,

I have two Date Field,

I am using two calendar object.

One for Start Date & second for End Date.

I am not able to find where I am going wrong for the same I have attached the QVW.

Can anyone help me on this urgently.

Re: Slider/Calendar Object Properties issue.

sunny_talwar — Wed, 24 Feb 2016 12:09:33 GMT

Try it out now:

Expression used: ='>=' & TimeStamp(vDateZero) & '<=' & TimeStamp(vEndDate)

But I suggest truncating your DEAL_DATE to just a date by using Date(DEAL_DATE) function in the script and then you can use this expression for filtering:

='>=' & Date(vDateZero) & '<=' & Date(vEndDate)

Re: Slider/Calendar Object Properties issue.

renuka_sasikumar — Wed, 24 Feb 2016 12:18:10 GMT

Hi,

Sorry I didn't get this.

I want when I select the StartDate in Calendar Object then my Table box should change according to it.

So not able to understand where I should write this expression.

Re: Slider/Calendar Object Properties issue.

maxgro — Wed, 24 Feb 2016 12:21:52 GMT

see the attachment

I modified

menù --> settings --> document properties --> number the format of DEAL_DATE

in text object Generate the search string = '>=$(=Date(vDateZero))<=$(=Date(vEndDate))'

Re: Slider/Calendar Object Properties issue.

sunny_talwar — Wed, 24 Feb 2016 12:22:26 GMT

Have you tried opening up the application that I have attached above? You had a button called Generate, I just fixed the expression in it to make it work. Now when you select a start and end date and click generate, the range selected in those two calendar objects will be selected.

Re: Slider/Calendar Object Properties issue.

renuka_sasikumar — Wed, 24 Feb 2016 12:58:14 GMT

Hi,

If I want to do the same thing without the Generate Text Box.

For eg: If I select Start Date & End Date then the data should be selected according to that in the Table Box.

Regards,

Renuka S

Re: Slider/Calendar Object Properties issue.

maxgro — Wed, 24 Feb 2016 13:03:58 GMT

add the same action and expression on the 2 variables

Re: Slider/Calendar Object Properties issue.

sunny_talwar — Wed, 24 Feb 2016 13:14:54 GMT

Check out the attached:

and just so you know, your Start date calendar is linked to a variable called vDateZero and you might want to consider switching it to vStartDate. and if you do that then the expression will change accordingly:

From

='>=' & TimeStamp(vDateZero) & '<=' & TimeStamp(vEndDate)

='>=' & TimeStamp(vStartDate) & '<=' & TimeStamp(vEndDate)

Re: Slider/Calendar Object Properties issue.

renuka_sasikumar — Thu, 25 Feb 2016 05:34:28 GMT

Thank you Sunny T.

Regards,

Renuka S

Re: Slider/Calendar Object Properties issue.

renuka_sasikumar — Wed, 16 Mar 2016 10:16:00 GMT

Hi,

I tried this with my actual data, I am facing issue like.

Here I have Two Calendar object i.e. StartDate & EndDate and one Bar chart in that Date is as Dimension.

Now here when i select the date between stat date & enddate no changes occur on Bar chart.

Can you help me on this.

Re: Slider/Calendar Object Properties issue.

sunny_talwar — Wed, 16 Mar 2016 10:29:42 GMT

Difficult to say anything without looking at issue