topic Range in QlikView

Range

janardhan — Tue, 30 Oct 2012 08:57:25 GMT

Hi Friends ,

if any one can give me an idea about this ,

i need sum in between OTG50 to OTG175 , for that i tried like this. its wrong expression. cany anyone help me

=RANGESUM(IF(ITEMID>='OTG50' - ITEMID<='OTG175' , LINEAMOUNT))

Thanks

jana

Re: Range

Anonymous — Tue, 30 Oct 2012 09:09:13 GMT

hi u can use

sum( {$<ITEMID= {“>=OTG50<=OTG175”}>} LINEAMOUNT)

hope it workz

regardz,

Vaibhav

Re: Range

janardhan — Tue, 30 Oct 2012 09:14:19 GMT

Hi vibhav,

i am getting error msg like : Error in set modifier ad hoc element list

Re: Range

Anonymous — Tue, 30 Oct 2012 09:31:40 GMT

Chk d Attached app

Re: Range

janardhan — Tue, 30 Oct 2012 12:17:51 GMT

Hi can any one tell me this expression is correct

shall i write like this

sum(if(ITEMID>='OTG050'and ITEMID<='OTG175',LINEAMOUNT) +
if(ITEMID>='OTG182'and ITEMID<='OTG192' , LINEAMOUNT) +
if(ITEMID>='OTG193'and ITEMID<='OTG196' , LINEAMOUNT))

Re: Range

jagan — Tue, 30 Oct 2012 12:52:34 GMT

Hi Janardhan,

It is much easier if you arrive a new field which holds numeric value from string

Ex: OTG050 as 50 in new field

LOAD

ITEMID,

Right(ITEMID) AS NewITEMID

FROM DataSource;

So now in your expression you can use straight away

=sum(if(NewITEMID>=50 and NewITEMID <=175,LINEAMOUNT) +
if(NewITEMID>=182and NewITEMID<=192 , LINEAMOUNT) +
if(NewITEMID>=193 andNewITEMID<=196 , LINEAMOUNT))

Hope this helps you.

Regards,

Jagan.

Re: Range

janardhan — Tue, 30 Oct 2012 12:55:26 GMT

Thanks for ur help , i have already done.