Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

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