topic Re: Set Analysis - Ignoring Filters with Expression in QlikView

Set Analysis - Ignoring Filters with Expression

Anonymous — Tue, 05 Sep 2017 20:15:43 GMT

I am using the following two expressions in two different charts:

Avg ( {<Year = , MONTH = ,Industry = , StateName =,Employer=,JobCategory= >} Offerings)

Using above to ignore all filters. The purpose being, I am showing a specific group score, compared to an average score.

((count({< LTwoR = {">=9"}>} LTwoR) - count({< LTwoR = {"<=6"}>} LTwoR))) / count(LTwoR)

The above formula is being used to calculate an NPS score. I am wanting to do the same as above. That is, show a specific group score and an average score that does not recalculate based on the filters.

How can I accomplish this?

Re: Set Analysis - Ignoring Filters with Expression

edmondo_tassi — Tue, 05 Sep 2017 20:35:36 GMT

I'm not sure to understand. if you want to ignore "all" filters you can use {1}.

However look at avg function, because sometimes is better write explicit ratio/n.

best regards.

Re: Set Analysis - Ignoring Filters with Expression

Anonymous — Tue, 05 Sep 2017 20:44:44 GMT

I have tried to incorporate {1} into the expression and I am not sure exactly how that should look. I have either gotten errors or no errors, but 0% as the output (and it shouldn't be zero).

Re: Set Analysis - Ignoring Filters with Expression

swuehl — Tue, 05 Sep 2017 21:03:03 GMT

Maybe

((count({1< LTwoR = {">=9"}>} LTwoR) - count({1< LTwoR = {"<=6"}>} LTwoR))) / count({1} LTwoR)

Re: Set Analysis - Ignoring Filters with Expression

Anonymous — Tue, 05 Sep 2017 21:08:28 GMT

That worked! Thank you SO MUCH!