Set Analysis - If Statement Producing Duplicates and Different Results

[#1]

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]

Hi.

The answer depends on your data model.

Could you post sample application ?

[SunilChauhan]

could you please attached same..

its seems like both expression have not difference