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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

SET EXPRESSION

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

Labels (1)
1 Solution

Accepted Solutions
swuehl
Champion III
Champion III

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

View solution in original post

3 Replies
MK_QSL
MVP
MVP

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

swuehl
Champion III
Champion III

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

upaliwije
Creator II
Creator II
Author

Thanks

It works following way also

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