Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense 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