topic Min and Max date in QlikView

Min and Max date

Fri, 22 Jan 2016 05:23:42 GMT

Hello All,

Could you please help me correct the below:

The mistake is by the "RESIDENT MSMEDIA" (In bold and underline)

MSMEDIA:

LOAD ID,

CampaignID,

QueueID,

UniversalTime,

UniversalTimeString,

AgentID,

AgentOid,

AgentLocalTime,

LocalTime,

Date(Floor(AgentLocalTime)) as Date_prise_en_charge,

Date(Floor(LocalTime)) as Date_Reception,

AgentUniversalTime,

AgentUniversalTimeString,

Time(Time#(WorkDuration,'ss'),'hh:mm:ss') as WorkDuration_1,

Time(Time#(WrapupDuration,'ss'),'hh:mm:ss') as WrapupDuration_1;

SQL SELECT *

FROM "HN_MediaServer".dbo.MSMedias WHERE CampaignID='E4136357942437B4';

MinMaxDate:

LOAD

Min(AgentLocalTime) as MinDate,

Max(AgentLocalTime) as MaxDate,

Resident MSMEDIA;

LET vMinDate=floor(peek('MinDate'));

LET vMaxDate=floor(peek('MaxDate'));

Drop Table MSMEDIA;

Many Thanks,

Hasvine

Re: Min and Max date

Anonymous — Fri, 22 Jan 2016 05:29:48 GMT

How AgentLocalTime stores the value??

Is it a mix of Date & Time both?

Re: Min and Max date

tamilarasu — Fri, 22 Jan 2016 05:30:02 GMT

Remove the extra comma after the Field name MaxDate.

MinMaxDate:

LOAD

Min(AgentLocalTime) as MinDate,

Max(AgentLocalTime) as MaxDate ,

Resident MSMEDIA;

Re: Min and Max date

Fri, 22 Jan 2016 05:32:13 GMT

Hello Balraj,

Yes actually it is DD/MM/YYYY HH:MM:SS

Thanks,

HAsvine

Re: Min and Max date

Anonymous — Fri, 22 Jan 2016 05:32:57 GMT

Check this as well?

Better Calendar Scripts | Qlikview Cookbook

QlikView script to generate a master calendar · GitHub

Re: Min and Max date

Fri, 22 Jan 2016 05:35:08 GMT

Thanks

I works 🙂