topic Re: how to create a start date and end date range in QlikView

how to create a start date and end date range

Wed, 25 Nov 2020 16:16:04 GMT

I have one date field name as WEEKLYDATE.

I need to create start date and end date by using WEEKLYDATE.

I will get data every week in M/D/YYYY format

When I select start date and end date user want to see last 52 weeks data only .

Thanks in Advance

Regards

Niranjan

Re: how to create a start date and end date range

sunny_talwar — Tue, 02 Aug 2016 13:47:07 GMT

You want this on the front end? Would you be able to provide a sample to look at?

Re: how to create a start date and end date range

Wed, 03 Aug 2016 07:29:34 GMT

Yes I want this front end..

I created two calendar objects Start date and End date..

But I am not getting dates

Re: how to create a start date and end date range

sunny_talwar — Wed, 03 Aug 2016 08:34:08 GMT

Would you be able to share a sample?

Re: how to create a start date and end date range

Mark_Little — Wed, 03 Aug 2016 08:56:33 GMT

Hi,

I would take a look at the articles on Master calendars, then you can start building from there.

But Like Sunny has suggested if you could share some more information on exactly what you want and some examples it would help guide you better,

Mark

Re: how to create a start date and end date range

Thu, 04 Aug 2016 06:17:09 GMT

Hi Sunny,

I am getting date format is

I created strat date and end date the date format is coming like

The dates are not coming into start date and end date.

I created two variables vStartDate and vEndDate and wrote =Min(WEEKLYDATE) and =Max(WEEKLYDATE)

My requirement is user can select start date and end date and by default it will show past 52 weeks data.

Do I need to change any in SET Analysis.

SET TimeFormat='h:mm:ss TT';
SET DateFormat='MM/DD/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Pls help.

Re: how to create a start date and end date range

sunny_talwar — Thu, 04 Aug 2016 10:25:53 GMT

To me it looks like that you are date are not read as dates. Can you try a list box expression: Num(WEEKLYDATE) and see if you see the dates changing into numbers or not? If they don't then probably your WEEKLYDATE is a text field where you won't be able find Max and Min.

You can fix this in the script like this:

LOAD Date(Floor(Date#(WEEKLYDATE, 'MM-DD-YYYY hh:mm:ss'))) as WEEKLYDATE

and then move from there. Also read here for more information related to dates

Get the Dates Right

Why don’t my dates work?

Re: how to create a start date and end date range

Thu, 04 Aug 2016 12:38:37 GMT

Hi Boppella,

1. Front end You use Calendar range Like From --> To

Edit Script -- >

SET @DateStart = CAST('01/' + @Parameter AS DATETIME) SET @DateEnd = DATEADD(DD, -1, DATEADD(MM, 1, @DateStart))

Or else:

Write in sql like start date and end date ..

Thanks

Nandu.