Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
thomas_2583
Contributor III
Contributor III
‎2020-06-01 06:48 AM

Measure Calculation Help

Hi,

Can anyone please help me with the correct syntax using the following logic, I can't get the NOT EQUAL to work within the statement below:

sum({<MYear={'2020'},GYear={'2020'},status NOT EQUAL {'tcu'}>}Spend)

442 Views
0 Likes
1 Solution

Accepted Solutions
Anil_Babu_Samineni
MVP
MVP
‎2020-06-01 06:59 AM

Perhaps this

sum({<MYear={'2020'}, GYear={'2020'}, status -= {'tcu'}>}Spend)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

431 Views
0 Likes
1 Reply
Anil_Babu_Samineni
MVP
MVP
‎2020-06-01 06:59 AM

Perhaps this

sum({<MYear={'2020'}, GYear={'2020'}, status -= {'tcu'}>}Spend)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
432 Views
0 Likes