Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

expression

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

1 Solution

Accepted Solutions
sunny_talwar

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))

View solution in original post

1 Reply
sunny_talwar

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))