Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: How to count records with two numeric conditions

Try this:

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

4 Replies
Not applicable

Re: How to count records with two numeric conditions

I found the solutions..

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

Re: How to count records with two numeric conditions

Try this:

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

buzzy996
Honored Contributor 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])

ramoncova06
Valued Contributor III

Re: How to count records with two numeric conditions

you can close your thread

Community Browser