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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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