topic Re: High Level Indicator in QlikView

High Level Indicator

prees959 — Mon, 06 Nov 2017 14:53:17 GMT

Hi,

I have 2 measures, sum(absences) and & sum(temp_workers), that I have in a single chart with WeekNumber on the x-axis.

What I would like to do is take these two measures and create two single textbox expressions at the top of my dashboard that portray that for what ever date range I have selected :

Week on Week the Absences are Reducing/Increasing
Week on Week the Temp Staff are Reducing or Increasing

eg something like

is this possible?

Many thanks,

Phil

Re: High Level Indicator

Anil_Babu_Samineni — Mon, 06 Nov 2017 15:12:04 GMT

Yes, This is possible with 4 objects and not from 2 objects

Re: High Level Indicator

maxgro — Mon, 06 Nov 2017 15:16:50 GMT

have a look at

Creating a KPI object in QlikView

Qlik Design Blog : Replacing images with Geomet... | Qlik Community‌

Re: High Level Indicator

jpenuliar — Mon, 06 Nov 2017 15:18:27 GMT

Have a look at the Sample App "Prescription Tracker". It has a solid example of what you want to achieve.

Re: High Level Indicator

prees959 — Mon, 06 Nov 2017 15:38:25 GMT

Hi thanks for the replies - I'm asking more about calculating the week-on-week figures.

Re: High Level Indicator

maxgro — Mon, 06 Nov 2017 16:12:01 GMT

if you have a Calendar with a serial week

you can calculate the % as

num(

(

sum({$<WeekSerial={'$(=max(WeekSerial))'},Year=,Month=,Date=>} Val)

sum({$<WeekSerial={'$(=max(WeekSerial)-1)'},Year=,Month=,Date=>} Val)

)

sum({$<WeekSerial={'$(=max(WeekSerial)-1)'},Year=,Month=,Date=>} Val)

, '#.##0%')

You can find a small example in the attachment

Re: High Level Indicator

prees959 — Tue, 07 Nov 2017 07:24:36 GMT

Hi, I'm getting some very large percentages with this solution. Will I have to include every field from my calendar in this section :

sum({$<WeekSerial={'$(=max(WeekSerial))'},Year=,Month=,Date=>} Val) ?

Many thanks again,

Phil

Re: High Level Indicator

maxgro — Tue, 07 Nov 2017 18:44:03 GMT

yes, the

Year=,Month=,Date=

is used to disregard the selections in Year, Month and Date fields

You can see the difference when I select a date

In the red box (set analysis without Year=,Month=,Date=), the result is that date, not the week of that date and the week before is 0