Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shyamcharan
Creator III
Creator III

Field A = Field B Condition in Sets Does not work

Hi Experts,

I am trying to use the below formula to create Sum of Value based on Fields Equal condition. But it does not work.

Any suggestions please?

Sum({<TimeArrived=TimeUnitAssigned>}Value)

Please find the attached file.

Thanks in advance,

Shyam.

1 Solution

Accepted Solutions
shyamcharan
Creator III
Creator III
Author

Thanks for your response Clever Anjos.

Thats quite help full link.

I also found the answer in the below link:

set_analysis_intra-record.qvw

Thanks heaps.

Shyam.

View solution in original post

4 Replies
Clever_Anjos
Employee
Employee

It´s not the way Set Analysis works (see here how to write your expressions A Primer on Set Analysis)

If you want to compare two fields you can use this =Sum(If(TimeArrived=TimeUnitAssigned,Value))

shyamcharan
Creator III
Creator III
Author

Thanks for your response Clever Anjos.

Thats quite help full link.

I also found the answer in the below link:

set_analysis_intra-record.qvw

Thanks heaps.

Shyam.

Clever_Anjos
Employee
Employee

Nice, so please consider closing the thread marking one answer as "Correct"

Best regards

shyamcharan
Creator III
Creator III
Author

Done!! Cheers.