topic WEEKLY in QlikView

WEEKLY

mario-sarkis — Tue, 12 May 2015 12:58:07 GMT

Hey all,

I need to know can i calculate a week on a set analysis

My problem is that i need to show a Gauge-chart that shows me a how the employee moves in term of his target (weekly target)

Ex :

employee has to do 5 Visits Per week and 35 callss per week either as a target

i want to calculate number on visits weekly to see if the employee reach their target

any help >?

Re: WEEKLY

robert_mika — Tue, 12 May 2015 13:04:03 GMT

Could you post your data or app?

Re: WEEKLY

Anonymous — Tue, 12 May 2015 13:09:50 GMT

If you have Week as one of your date attributes, it shouldn't be a problem. Not sure why you mention set analysis here - you may need or not need it depending on the specific situation.

Re: WEEKLY

Tue, 12 May 2015 13:12:47 GMT

Hey Mario,

Is it a static week or a rolling 7day calculation you like to do?

count( {<Week= {$(=Max(Week)-1)}>} Visits ) shows the visits for previous week and should be able to just use to a chart with the employees as dimension.

Re: WEEKLY

mario-sarkis — Tue, 12 May 2015 13:17:32 GMT

Hi Robert ,

First i have a field look like this

Interaction:

6/1/2014 6:51:25PM

7/31/2014 7:16:15PM

12/3/2014 6:15:20PM

how can separate the date from time

second i need to calculate the weekly number of interaction.

Thank you

Re: WEEKLY

Anonymous — Tue, 12 May 2015 13:28:53 GMT

To separate date from time, use date(floor()) function to get the date, and time() function to get time. See for example
=date(floor(timestamp#('6/1/2014 6:51:25PM','M/D/YYYY h:mm:ssTT')))
=time(timestamp#('6/1/2014 6:51:25PM','M/D/YYYY h:mm:ssTT'))

You need to replace '6/1/2014 6:51:25PM' with the actual field name (I assume "Interaction")

To get the "weekly number of interaction" just create a chart (table) with dimension Week and expression count(Interaction)

Re: WEEKLY

mario-sarkis — Tue, 12 May 2015 13:35:32 GMT

can i write it like this in the script ?

Re: WEEKLY

Anonymous — Tue, 12 May 2015 13:37:26 GMT

Almost:

date(floor(timestamp#('6/1/2014 6:51:25PM','M/D/YYYY h:mm:ssTT'))) as Date

time(timestamp#('6/1/2014 6:51:25PM','M/D/YYYY h:mm:ssTT')) as Time

Re: WEEKLY

robert_mika — Tue, 12 May 2015 13:44:29 GMT

load

WeekStart(floor(timestamp#(Interaction,'M/D/YYYY h:mm:ssTT'))) as Weekstart,

date(floor(timestamp#(Interaction,'M/D/YYYY h:mm:ssTT'))) as Date,

time(timestamp#(Interaction,'M/D/YYYY h:mm:ssTT')) as Time

inline [

Interaction

6/1/2014 6:51:25PM

7/31/2014 7:16:15PM

12/3/2014 6:15:20PM

]

Dimension for Chart WeekStart

Expression Count(Date)

]

Re: WEEKLY

mario-sarkis — Tue, 12 May 2015 15:22:03 GMT

it is not working like this in the script

can u help and show me how to write it in the script ?

Re: WEEKLY

mario-sarkis — Tue, 12 May 2015 15:27:39 GMT

oh sorry it works thanks alot