I am trying to compare two fields in Qlikview with Set Analysis. Logic is working with if condition but lot of fields needs to be applied so I am trying to avoid if condition and want to have set analysis(Need to apply more 6 fields) !.
Attached is the Qlikview Application with Straight table that has an expression of if and needs to be converted in the set analysis.
As there are lot more fields going to come and Its many to many relationship with the data and dimension.If I tried to do it in the backend it might increase the fact. So its very difficult to do it in backend.