topic Count nos between range specified in QlikView

Count nos between range specified

Tue, 27 Sep 2016 15:30:10 GMT

Hello friends !!!!

Need your help

I want to count those Dno as shown below which is ( >=-30 and <=30)

Dno	Value
1	30
2	100
3	-10
4	35
5	30
6	-26
7	20
8	16
9	-30
10	125
11	15
12	12
13	26
14	170
15	14
16	120

Re: Count nos between range specified

sunny_talwar — Tue, 27 Sep 2016 15:32:45 GMT

May be this:

Count({<Value = {'>=-30<=30'}>}Dno)

Re: Count nos between range specified

miguelbraga — Tue, 27 Sep 2016 15:50:56 GMT

Hey there,

Take the expression of stalwar1as the correct one, but if you want, make two variable like vFrom and vTo and use those into the expression like this:

= Count({<Value = {'>=$(vFrom) <=$(vTo)'}>}Dno)

This way you can have a input box to be more dinamic and practical.

Best regards,

D.A. MB

Re: Count nos between range specified

miguelbraga — Tue, 27 Sep 2016 15:54:41 GMT

See the attached file: