topic Re: Range Expression 2 in QlikView

Range Expression 2

MalcolmCICWF — Fri, 04 Jan 2013 16:43:36 GMT

I want to do a range expression where any of my codes that are 2000's are counted and if they are 2000's-3000's they are counted.The codes range from 1000-5000, but what I am using seems to be counting all the codes no matter what I change the range to. Can anyone help me figure out how to count just specific codes for these in report expressions?

Here is what I have that isnt working.

COUNT(IF(DISPO>=2000,1

and DISPO<=3801,1))

Re: Range Expression 2

Fri, 04 Jan 2013 20:55:02 GMT

I can't see the image you posted, but have you tried using a mapping load in the script? That should do the trick.

Re: Range Expression 2

MalcolmCICWF — Fri, 04 Jan 2013 21:00:49 GMT

Sorry, I have updated the picture in my original post.

Re: Range Expression 2

Fri, 04 Jan 2013 21:11:16 GMT

Hmm. I still can't see it. 😕

Re: Range Expression 2

MalcolmCICWF — Mon, 07 Jan 2013 14:36:02 GMT

I just pasted the damn code this time lol. I also changed up the wording a bit to explain where I am using it. This is on the front end of my report where I am trying to create expressions for a char tin my report.

Re: Range Expression 2

Mon, 07 Jan 2013 16:00:22 GMT

To count only the codes in the 2000's:

=Count({<DISPO={">=$(=2000) <=$(=3000)"}>} DISPO)

To count only the codes in the 2000's and 3000's:

=Count({<DISPO={">=$(=2000) <=$(=4000)"}>} DISPO)