Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ajmayers
Contributor
Contributor

KPI report combining expressions

Hi all

I am fairly new to Qlikview expressions and trying to build a KPI report.

I essentially have two product 'schemes' that have different service level (SLA) times in days, one is 3 days and one is 5 days.

I am trying to get a number (count) of how many diary tasks have been done within the SLA to get a total figure each month so I can then report it as a % against the total of all tasks.

I have managed to build all of the components separately to get raw figures, but I am struggling to combine them into one total figure.

What I have so far as expressions in a straight table chart:

Diary Total (excl Post)

 

= count ({< 
TaskItem -= {'*Post*'},
TaskCompletedDateWithoutTime = {'$(vLastMonthDateRange)'}
>}  TaskID)

 

SLA (days)

 

=if (WildMatch([Scheme Name], '*PRODUCTONE*'),3,5)

Days Between

 

 

=NetWorkDays(TaskDueDate,TaskCompletedDateWithoutTime)

In SLA?

 

 

=if([Days Between] <= [SLA (days)],1,0)

 

The date range is set as a variable so it is dynamic each month, but essentially is formatted as '>=01/12/2018<=31/12/2018'

These work great when in a in a table showing each row of data with a Text Count total on the top of the columns, but I have a summary box, which is for the KPI totals and I am struggling to combine them effectively

chart.png
totals.pngSo as an example if I have 75 tasks in SLA and 109 total, I want the KPI to show 68.8 or 68.8% for the month in SLA. (In picture it is just the count at present)

 

Any suggestions on the best way to do this?

Many thanks

Labels (3)
1 Reply
prieper
Master II
Master II

a formula like

COUNT(IF(NETWORKDAYS(Due, Compl) <= SLA,  ID))
/
COUNT(ID)

should do the trick.

Please find an example attached.

Peter