topic Re: Date division based on AM and PM in QlikView

Date division based on AM and PM

iahmadmca1 — Fri, 14 Apr 2017 05:40:13 GMT

Team,

I just want to ask something regarding date division based on AM and PM as for example.

I have one date column like DATE which contains the both date like AM and PM I want to separate average of AM date and PM date.Please refer the below table for more details.

Date
01/02/2017 AM
01/03/2017 PM
01/04/2017 AM
01/05/2017 PM

Need to calculate the average of 01/02/2017 AM,01/04/2017 AM, and 01/03/2017PM,01/05/2017 PM both AM and PM average I need to calculate separate; could you please help me to do this requirement.

Thanks,

Irshad Ahmad

Re: Date division based on AM and PM

Anonymous — Fri, 14 Apr 2017 06:18:29 GMT

Like this??

load Pick(Flag,'AM','PM') as type,avg(Value) Group by Flag;

Load *,WildMatch(Date,'*AM*','*PM*') as Flag inline

[Date,Value

01/02/2017 AM,10

01/03/2017 PM,20

01/04/2017 AM,30

01/05/2017 PM,40];

Re: Date division based on AM and PM

MK_QSL — Fri, 14 Apr 2017 06:31:51 GMT

like this?

Re: Date division based on AM and PM

iahmadmca1 — Fri, 14 Apr 2017 14:06:56 GMT

Thanks, Manish.