Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
brf10043
Creator
Creator

Yet another Set Analysis question

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.

1 Solution

Accepted Solutions
sunny_talwar

Try this:

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

View solution in original post

2 Replies
sunny_talwar

Try this:

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

brf10043
Creator
Creator
Author

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