High Level Indicator

[prees959]

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 :

1. Week on Week the Absences are Reducing/Increasing
2. Week on Week the Temp Staff are Reducing or Increasing

eg something like

  

is this possible?

Many thanks,

Phil

[Anil_Babu_Samineni]

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

[maxgro]

have a look at

Creating a KPI object in QlikView

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

[jpenuliar]

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

[prees959]

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

[maxgro]

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

[prees959]

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

[maxgro]

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