topic Re: Set Analysis - If Statement Producing Duplicates and Different Results in QlikView

Set Analysis - If Statement Producing Duplicates and Different Results

Sun, 27 Jul 2014 14:47:07 GMT

Hi All,

I am new to Qlikview and Set Analysis.

I am using below statement in Set Analysis.

=if(sum({<ReportingMonth = {'<$(=Max(ReportingMonth))'}>}[Review?])>0,'No','Yes')

if i used only sum({<ReportingMonth = {'<$(=Max(ReportingMonth))'}>}[Review?])

then, I am getting expected results.

but,if i include

If Part like above,

then,

I am getting duplicates results.

can someone help with that ?

Thanks!

whiteline — Mon, 28 Jul 2014 06:42:27 GMT

Hi.

The answer depends on your data model.

Could you post sample application ?

SunilChauhan — Mon, 28 Jul 2014 06:48:32 GMT

could you please attached same..

its seems like both expression have not difference