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

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
We are aware of an issue with the Product Downloads page and looking into it.
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)

798 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

787 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
788 Views
0 Likes