topic Re: using greater than and less than in expression in QlikView

using greater than and less than in expression

rcorcoran — Mon, 09 Feb 2015 10:22:21 GMT

Hi I have this expression and want to show it as sum of CAMHS124 where it is >=7 or <=26

any help would be great

Thanks

num((((Sum({$<[CAMHS124]={7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,},ReferredMM={1}>}ActualValue)))), '##0'),

tresB — Mon, 09 Feb 2015 10:25:15 GMT

Try like:

....<[CAMHS124]={">=7 <=26"}..

sagarkharpude — Mon, 09 Feb 2015 10:33:05 GMT

Try this

=sum({<[CAMHS124] = {">=7<=26"},ReferredMM={1}>} ActualValue)

rcorcoran — Mon, 09 Feb 2015 10:37:36 GMT

Thanks so much for your help both right.

Rhona

rcorcoran — Mon, 09 Feb 2015 10:37:51 GMT

Thanks you sagar that works fine

rcorcoran — Mon, 09 Feb 2015 10:38:09 GMT

Than you again tresesco that works great

Rhona