Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
New Contributor II

KPI within a KPI

I have a data of your Fiscal years. 

I need to create a KPI which displays two values. The main one will give the CollectionRate, and the second one the CollectionRate for the year before. When viewing the sheet, when I use the Year filter to select 2017, the values should show 2017 rate along with 2016 rate. 

The year is taken from the patient admission date and the CollectionRate=TotalPayed/TotalCharged

1 Reply

Re: KPI within a KPI

use set analysis and create your KPIs something like below. 

sales for the current/max year (or selected) Sum({<Year={"$(=Max(Year))"}>}LineSalesAmount)

sales for the previous year -  Sum({<Year={"$(=Max(Year)-1)"}>}LineSalesAmount)