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: 
Sheetal
Contributor II
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
dplr-rn
Partner - Master III
Partner - Master III

try set analysis

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

share some sample data so we can help further

View solution in original post

4 Replies
sunny_talwar

May be try this

=Count({<[Evaluation_Data$.response_value] = {">=4.5<=5"}>}[Evaluation_Data$.response_value])
dplr-rn
Partner - Master III
Partner - Master III

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

Thanks. That worked.

sunny_talwar

Awesome, we are glad it did.