Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I filter to only display results when the count is >5?

I have a survey results report.  How do I filter the report to only display results when the number of responses, per survey question, is >5?  In the example below, I would only want to show the results for Q1 and Q2, since Q3 total responses are <5.

For example:

     Question      # Responses

        1                   10

        2                    5

        3                    4

1 Solution

Accepted Solutions
padmanabhan_ram
Creator II
Creator II

please find the attached solution.

Br,

Padmanabhan

View solution in original post

5 Replies
swuehl
MVP
MVP

If Question is the dimension and # Responses the expression in a straight table chart, you could use for example (there are mulitple ways to do this) dimension limits:

Open the chart properties, go to dimension limits tab.

Select Question dimension and enable limits checkbox with options 'Show only values that are' 'greater than' '5' 'exact amount'

Disable 'Show Others' checkbox if not needed.

Not applicable
Author

Thank you for the quick response! I am not seeing a limits checkbox. Here is my display:

The “Confidence Level” dimension is my “Question”

padmanabhan_ram
Creator II
Creator II

please find the attached solution.

Br,

Padmanabhan

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

Chart:

Dimension: Question

Expression: If(Sum(Responses) > 5, Sum(Responses))

Not applicable
Author

That works for one dimension.  How to I modify this if I have two dimensions, for example:

Question

    Location 1    10

    Location 2    3

I want the report to display Location 1 and value 10, but not display Location 2.