topic Re: sum for range values in QlikView

sum for range values

Anonymous — Tue, 11 Mar 2014 04:59:32 GMT

hi,

i need to calculte value for range for exm:

how many orders i have with 1-20 items, and 21-35 items , and 35-40 items and so on...

i write - count({<numitem={'>1or<20'}>}ordersnumber

but it doesn't work good in all Cases.

how do i need to write it ?

thanks'

yarin.

tresB — Tue, 11 Mar 2014 05:01:35 GMT

If you have equi length gaps, you can try class().

er_mohit — Tue, 11 Mar 2014 05:04:48 GMT

try this way

count({<numitem={'>=1<=20'}>}ordersnumber)

count({<numitem={'>=21<=35'}>}ordersnumber)

count({<numitem={'>=36<=40'}>}ordersnumber)

or try this way in script side

RangeOnly(if(numitem>=1 and numitem<=20,'1-20 Items',

RangeOnly(if(numitem>=21 and numitem<=35,'21-35 Items',

RangeOnly(if(numitem>=35 and numitem<=40,'35-40 Items')))))) as Field