Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
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
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?