Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

kvijay173
New Contributor III

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
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))

2 Replies
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))

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

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

Community Browser