Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
pavithrarshetty
Creator II
Creator II

How do I display the bell curve for overall count?

Here is the example attached. Please help me.

1 Solution

Accepted Solutions
sunny_talwar

May be like this:

Capture.PNG

Sum({1<%VisitType={'NPV'}>}%ProcedureCNT)/Sum({1<%VisitType={'NPV'}>}Total %ProcedureCNT)

View solution in original post

3 Replies
sunny_talwar

May be like this:

Capture.PNG

Sum({1<%VisitType={'NPV'}>}%ProcedureCNT)/Sum({1<%VisitType={'NPV'}>}Total %ProcedureCNT)

View solution in original post

sunny_talwar

Or this if you just want to ignore selection in Department

Sum({<%VisitType={'NPV'}, Department>}%ProcedureCNT)/Sum({<%VisitType={'NPV'}, Department>}Total %ProcedureCNT)

pavithrarshetty
Creator II
Creator II
Author

This works for me. I did new that I have to use "1". But did not know where! Pretty Tricky!

Thanks for your help

Pavithra Shetty