Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to count records with two numeric conditions

I need to count the records that have values between 0 and  7,  I`m using the included expression, but with this one it count also records in negative

count(DISTINCT {<dayss ={'<=7'}>}[CONTRATOi])

1 Solution

Accepted Solutions
Highlighted

Re: How to count records with two numeric conditions

Try this:

Count(DISTINCT {<dayss ={'>=0<=7'}>}[CONTRATOi])

View solution in original post

4 Replies
Highlighted
Not applicable

Re: How to count records with two numeric conditions

I found the solutions..

count({ $<dayss={'>0<=7'}>} distinct CONTRATOi)

Highlighted

Re: How to count records with two numeric conditions

Try this:

Count(DISTINCT {<dayss ={'>=0<=7'}>}[CONTRATOi])

View solution in original post

Highlighted
Master II
Master II

Re: How to count records with two numeric conditions

the other way,

count(DISTINCT {<dayss ={'0','1','2','3','4','5','6','7'}>}[CONTRATOi])

Highlighted
Specialist III
Specialist III

Re: How to count records with two numeric conditions

you can close your thread