topic Re: Difference between nested if's and set analysis? in QlikView

Difference between nested if's and set analysis?

nikhilgarg — Mon, 24 Aug 2015 06:46:19 GMT

Hello,

Can anyne tell me the Difference between nested if's and set analysis ?

Thanks

Re: Difference between nested if's and set analysis?

jagan — Mon, 24 Aug 2015 06:51:56 GMT

Hi Nikhil,

There is no comparison between Nested IF and Set Analysis.

Set Analysis is to restrict the data in Charts / Expressions, where as Nested IF is used to conditionally apply some logic.

What you want to compare with Nest If & Set Analysis? If you come up with an example it would be easier to give the answer.

Regards,

Jagan.

Re: Difference between nested if's and set analysis?

nikhilgarg — Mon, 24 Aug 2015 06:55:40 GMT

Hey Jagan

it is an interview qstn asked to me in TCS. Even i am also confused how we can compare these 2. but someone told em that set analysis works faster than nested if's. Is it so?

Re: Difference between nested if's and set analysis?

jagan — Mon, 24 Aug 2015 07:03:56 GMT

Yes, Generally Set Analysis is faster than using If, that's for sure no doubt about that.

Regards,

Jagan.