Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

count if greater than or equal to 50% and lesser than or equal to 75%

Hi,

Below is my data. I would like to count the date entries if the In Octets % is greater than or equal to 50% and lesser than or equal to 75%. The result has to be 4. Please help to achieve the expression.

                                                                                                                                                                                   

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: count if greater than or equal to 50% and lesser than or equal to 75%

=COUNT(DISTINCT IF([In Octets %] >= 50 and [In Octets %] <=75,Date))

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: count if greater than or equal to 50% and lesser than or equal to 75%

=COUNT(DISTINCT IF([In Octets %] >= 50 and [In Octets %] <=75,Date))

View solution in original post

Highlighted

Re: count if greater than or equal to 50% and lesser than or equal to 75%

=Count({$< [In Octets %] = {">=50<=75"}>} DISTINCT Date)