topic Re: Converting If Condition To Set Analysis in QlikView

Converting If Condition To Set Analysis

Fri, 24 Feb 2017 08:14:41 GMT

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

Re: Converting If Condition To Set Analysis

sunny_talwar — Fri, 24 Feb 2017 10:43:43 GMT

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

Re: Converting If Condition To Set Analysis

nagarjuna_kotha — Fri, 24 Feb 2017 10:51:20 GMT

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

Re: Converting If Condition To Set Analysis

Fri, 24 Feb 2017 15:17:36 GMT

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