topic Re: Using KPI in QlikView

Using KPI

dezmundw15 — Mon, 23 Oct 2017 20:45:46 GMT

Hi All,

I am new to Qlik Sense and I want to try to use a KPI to Count the number of "NO" from the following table

PATIENT NAME	CHART NOTE TYPE	SERVICE DATE	PROVIDER	SIGNED	SIGNED BY	SIGNED ON
Patient7	SOAP Note	8/11/2017	Doctor 1	Yes	Doctor 1	8/11/2017
Patient11	SOAP Note	7/10/2017	Doctor2	Yes	Doctor2	7/11/2017
Patient13	SOAP Note	10/3/2017	Doctor1	Yes	Doctor1	10/3/2017
Patient15	SOAP Note	10/10/2017	Doctor2	No	Doctor2
Patient8	SOAP Note	1/17/2017	Doctor 2	Yes	Doctor 2	1/18/2017
Patient2	SOAP Note	2/16/2017	Doctor3	Yes	Doctor3	2/17/2017
Patient3	SOAP Note	3/16/2017	Doctor3	Yes	Doctor3	3/17/2017
Patient4	SOAP Note	7/27/2017	Doctor3	Yes	Doctor3	7/27/2017
Patient6	SOAP Note	5/8/2017	Doctor3	No	Doctor3
Patient5	SOAP Note	4/13/2017	Doctor3	No	Doctor3
Patient10	SOAP Note	4/19/2017	Doctor3	Yes	Doctor3	4/19/2017
Patient9	SOAP Note	5/24/2017	Doctor3	No	Doctor3
Patient1	SOAP Note	6/27/2017	Doctor3	Yes	Doctor3	6/27/2017

The KPI would have the total Soap Notes and the added dimension would show the # of No, Soap Notes that have not been completed. Can someone help me what the function may be.

Thanks for all of your help in advance.

Desmond

Re: Using KPI

devarasu07 — Tue, 24 Oct 2017 01:49:41 GMT

Hi,

If you wish to calculate the SIGNED flag you can use below way

if(len([SIGNED ON])<=0,'NO','YES') as SIGNED_Flag

Try like this, using the Text object

= '# of No, Soap not completed' &Chr(10)& count({<SIGNED={'NO'}>}[PATIENT NAME])

='Total Soap Notes' & Chr(10)& Count(distinct [PATIENT NAME])

or use KPI object like below screen shot

'# of No, Soap not completed

=count({<SIGNED={'NO'}>}[PATIENT NAME])

Total Soap Notes

= Count(distinct [PATIENT NAME])

Re: Using KPI

vikasdesai — Tue, 24 Oct 2017 05:39:10 GMT

Hello

To Count the number of "NO"

Use Following Expression as Measure in KPI

Count({$<SIGNED={'No'}>}SIGNED)

AND for Total Soap Notes

Count({$<CHART NOTE TYPE={'SOAP Note'}>}CHART NOTE TYPE)

Regards

Vikas

Re: Using KPI

dezmundw15 — Tue, 24 Oct 2017 14:50:45 GMT

Thank You guys, both approaches worked. I was really close with my script as compared with Vikas. I am learning more everyday. Are there some other guides I can use to get better at scripting that you all may have used?