Converting If Condition To Set Analysis

[#1]

Hi,

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.

Thanks,

Piyush

[sunny_talwar]

I don't think this can be converted to set analysis with the way the data is structured right now.

[nagarjuna_kotha]

U can't compare in in set analysis ,

Try to create flags in back end adn filter it out in front end.

In expression if don't want to use if condition in set analysis , then create one calution dimention an apply supress null value.

-Nagarjun

[#4]

Thanks for the reply.

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.

Thanks,

Piyush