Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Sheetal
New Contributor II

Filtering a table column

I have a table with the following columns

Date    |     5's    |   4's  |    3's  |  2's  |    1's

The 5's , 4's  etc is the count of a field called responsevalue in the view.

For 5's , The value should be a count of all responses where the response value is between 4.5 and 5. I am using the following query in the expression for column 5's, but not getting the desired output;

=if([Evaluation_Data$.response_value]>=4.5 and [Evaluation_Data$.response_value]<=5, Count([Evaluation_Data$.response_value]))

Can someone please help with this. Thanks.

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Filtering a table column

try set analysis

Count( {<[Evaluation_Data$.response_value]={">=4.5 <=5"}>} [Evaluation_Data$.response_value])

share some sample data so we can help further
4 Replies

Re: Filtering a table column

May be try this

=Count({<[Evaluation_Data$.response_value] = {">=4.5<=5"}>}[Evaluation_Data$.response_value])
Highlighted
Partner
Partner

Re: Filtering a table column

try set analysis

Count( {<[Evaluation_Data$.response_value]={">=4.5 <=5"}>} [Evaluation_Data$.response_value])

share some sample data so we can help further
Sheetal
New Contributor II

Re: Filtering a table column

Thanks. That worked.

Re: Filtering a table column

Awesome, we are glad it did.