Compare several fields to several variables

Mon, 17 Feb 2014 23:25:45 GMT

Hello all, hopefully you can assist me on an issue I'm having.

For a dashboard I'm putting together, I want to implement a more complex What-If analysis. Specifically, I have three fields corresponding to scores on pre-employment assessments (V1, V2, & V3) and three cutscore variables (v1cut, v2cut, & v3cut) that can be set by the user via an input box. What I want to show is the proportion of applicants who have scores which exceed all of the cutscores and have been fired from the job. Using the following expressions:

=Avg({<V1={">=$(v1cut)"}>}Fired)

=Avg({<V2={">=$(v2cut)"}>}Fired)

=Avg({<V3={">=$(v3cut)"}>}Fired)

I can show what the rate is considering each of the variables separately. However, I want a way to combine them and show the failure rate for folks whose V1 exceeds v1cut AND V2 exceeds v2cut AND V3 exceeds v3cut. I've tried calculating a field in the script and adding a reload button, but this doesn't work in the web view, which is how the app will be used. Any insight would be much appreciated. I've attached a .qvw just in case it helps to get a handle on things.

Thanks!

-Mike

Re: Compare several fields to several variables

marcus_sommer — Tue, 18 Feb 2014 07:42:09 GMT

Perhaps this approach is helpful for you.

- Marcus

topic Re: Compare several fields to several variables in QlikView

Compare several fields to several variables

Re: Compare several fields to several variables