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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
maxsheva
Creator II
Creator II

Set Analysis. Field is not equal other field.

Hi,

How can I replace expression below with set analysis?

if(Field1=Field2, 0, Sum(Value))

I tried different variants. For example this one doesn't work as well.

Sum({$<Field1-=Field2>} Value)

10 Replies
Anil_Babu_Samineni

FYI - I don't prefer to use direct set analysis. Because, Recently i had faced and took big challenge when this project on live. When i use that expression i am getting triple of the records like if i have script used like i mentioned it showing as expected but when i use Set analysis direct it consume triple like 3x. I wonder, That time that is cause some triggering issue i feel. Any how - You got the output. That's good

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