Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
dezmundw15
Contributor III
Contributor III

Using KPI

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 NAMECHART NOTE TYPESERVICE DATEPROVIDERSIGNEDSIGNED BYSIGNED ON
Patient7SOAP Note8/11/2017Doctor 1YesDoctor 18/11/2017
Patient11SOAP Note7/10/2017Doctor2YesDoctor27/11/2017
Patient13SOAP Note10/3/2017Doctor1YesDoctor110/3/2017
Patient15SOAP Note10/10/2017Doctor2NoDoctor2
Patient8SOAP Note1/17/2017Doctor 2YesDoctor 21/18/2017
Patient2SOAP Note2/16/2017Doctor3YesDoctor32/17/2017
Patient3SOAP Note3/16/2017Doctor3YesDoctor33/17/2017
Patient4SOAP Note7/27/2017Doctor3YesDoctor37/27/2017
Patient6SOAP Note5/8/2017Doctor3NoDoctor3
Patient5SOAP Note4/13/2017Doctor3NoDoctor3
Patient10SOAP Note4/19/2017Doctor3YesDoctor34/19/2017
Patient9SOAP Note5/24/2017Doctor3NoDoctor3
Patient1SOAP Note6/27/2017Doctor3YesDoctor36/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

3 Replies
devarasu07
Master II
Master II

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])

Capture.JPG

vikasdesai
Partner - Contributor III
Partner - Contributor III

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

dezmundw15
Contributor III
Contributor III
Author

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?