topic Re: expression in QlikView

expression

upaliwije — Thu, 04 Aug 2016 04:46:57 GMT

Hi Friends

The foll expression does not work in order

sum({<MONTH={'Jan','Feb','Mar','Apr','May,'Jun'}>},rangesum(CL_PROV,+CL_ADJUS,-RE_PROV-RF_PROV))

But If I remove {<MONTH={'Jan','Feb','Mar','Apr','May,'Jun'}>} It works well

Can some one help me the error I have made

sunny_talwar — Thu, 04 Aug 2016 04:49:47 GMT

Try removing the comma after the end of curly bracket

sum({<MONTH={'Jan','Feb','Mar','Apr','May,'Jun'}>},rangesum(CL_PROV,+CL_ADJUS,-RE_PROV-RF_PROV))

Into

Sum({<MONTH={'Jan','Feb','Mar','Apr','May,'Jun'}>} Rangesum(CL_PROV, CL_ADJUS, -RE_PROV-RF_PROV))