KPI creation

[aishwarya_203]

Hi,

I want to create a series of KPI that show only the new diagnosis that were made that particular year. 

So example if I had 405 diagnosis made in 2019 and 450(overall) in 2020, I want my 2020 diagnosis to only show 95.

Field names: Diagnosis year and Diagnosis count

I am fairly new to Qlik so any help is appreciated 

Thank you 🙂  

[Chanty4u]

Hi,

you can use below expressions.

count(diagnosiscount)      ------------  here you can select year from your filterpane or listbox so that it will show expected result.

or

count({<Year={2020}>}diagnosiscount)

[aishwarya_203]

Thanks for the response.

I am using the following for 2019 KPI

Count({$<[Diagnosis Year]= {"2019"}>}[#Diagnosis Count]) 

Now for 2020, I want only the new diagnosis made in 2020 

I tried the following but it does not work, it give me the value as 0

Count({$<[Diagnosis Year]= {"2021-1"}>}[#Diagnosis Count])

Not sure what is wrong

Thanks  

[Chanty4u]

use below directly

Count({$<[Diagnosis Year]= {2020}>}[#Diagnosis Count])

or

Count({$<[Diagnosis Year]= {"2020"}>}[#Diagnosis Count])