topic RE: Range Selections in Calendar object. in QlikView

RE: Range Selections in Calendar object.

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have 2 date fields, 1.Shipped Date 2.Picked Date.

The requirement is to add Shipped Date Picked Date as select criteria. We need range of date select criteria.

On Shipped Date by default we should have the last 3 months date range selected and the Charts should get the data based on these selections.If they filter by Picked Date first then filter Demand Date, the demand Date should only filter based on the data that is already filtered by Picked Date.This is true vice versa.

Please help me on this requirement..

Re: RE: Range Selections in Calendar object.

techvarun — Tue, 05 Sep 2017 04:26:30 GMT

Try below

How to set Minimum and Maximum Date in calendar

Re: RE: Range Selections in Calendar object.

techvarun — Tue, 05 Sep 2017 04:27:11 GMT

Or this

SQL Server + DatePicker

Re: RE: Range Selections in Calendar object.

Tue, 05 Sep 2017 04:50:10 GMT

Hi Varun,

That doesn't give me suitable answer.

I need to have last 3 months of data in my charts by default when i open the app. In calendars also the dates should be get selected(Start Picked Date is Today's date and End Picked Date is before 3rd month date from today).

And also the selections made in the calendars should get reflected in the charts as well.

Re: RE: Range Selections in Calendar object.

Tue, 05 Sep 2017 04:52:48 GMT

Please help me on this because it is very urgent requirement to be finished.

Re: RE: Range Selections in Calendar object.

techvarun — Tue, 05 Sep 2017 05:25:39 GMT

Share a sample qvw

Re: RE: Range Selections in Calendar object.

Tue, 05 Sep 2017 07:38:36 GMT

Sorry i can't share you as it is confidential to do that. But i can explain you the req clearly.

I have 2 fields i.e Shipped Date and Picked Date. i need to create calendar selections which are date range selections(Start Picked Date,End Picked Date, Start Shipped Date and End Shipped Date). .

On opening the qvw ,by default in Shipped date selections need to get last 3 months data.

If they filter by Picked Date first then filter Shipped Date, the Shipped Date should only filter based on the data that is already filtered by Picked date. This is true vice versa.