Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Contributor II

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

please find the attached solution.

Br,

Padmanabhan

5 Replies
MVP
MVP

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

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

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

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
Contributor II

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

please find the attached solution.

Br,

Padmanabhan

MVP
MVP

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

Hi,

Try like this

Chart:

Dimension: Question

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

Not applicable

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

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.

Community Browser