Week

mario-sarkis — Tue, 12 May 2015 12:55:12 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: Week

Tue, 12 May 2015 13:13:32 GMT

I assume you have the date columns available to base your Gauge on.

You can easily workout the Week. there are a wide range of week function in qlikview:

Week

WeekStart

WeekEnd

Weekyear

WeekDay

Assuming you have the date Available in a year format

Create a Chart of type Gauge.

In this chart type the dimension is not needed

Define your expresion your weekly target

go to presentation TAB

you can define your segments in this tab: Your segments is like the ranges that you define for different criteria.

it is a way to map a color to a value.

I hope this helps. If you want an example on the Gauge chart please shout