topic Yet another Set Analysis question in QlikView

Yet another Set Analysis question

brf10043 — Wed, 24 Feb 2016 18:38:43 GMT

How do I modify the following statement so that it calculates for all data ignoring any filtering from the User?

num(count({<EXPERIENCE_RATING={'Negative'}>}EXPERIENCE_RATING)/COUNT(FEEDBACK_ID), '#,##0.0%')

I've tried the following but it didn't work.

num(count({1<EXPERIENCE_RATING={'Negative'}>}EXPERIENCE_RATING)/COUNT(FEEDBACK_ID), '#,##0.0%')

Thanks.

sunny_talwar — Wed, 24 Feb 2016 18:41:10 GMT

Try this:

Num(Count({1<EXPERIENCE_RATING={'Negative'}>}EXPERIENCE_RATING)/COUNT({1}FEEDBACK_ID), '#,##0.0%')

brf10043 — Wed, 24 Feb 2016 18:48:42 GMT

Oh Yeah! That did it. Just missing that last {1}