topic SET EXPRESSION in QlikView

SET EXPRESSION

upaliwije — Sat, 15 Aug 2015 08:48:44 GMT

Hi Friends

I have following expression which is incorrect

sum({<NOs={">=0" OR {'A'}>}rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))

I want to range sum given fields if Nos>=0 or Nos=A

Pls help to correct my expression

MK_QSL — Sat, 15 Aug 2015 08:52:51 GMT

sum({<NOs={">=0"}> +<NOs = {'A'}>}rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))

swuehl — Sat, 15 Aug 2015 08:55:07 GMT

sum({<NOs={">=0"} + {'A'} >} rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))

upaliwije — Sat, 15 Aug 2015 08:59:54 GMT

Thanks

It works following way also

sum({<NOs={">=0","A"}>}rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))