Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 >?
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