Sum of Distinct Issue In Qlikview

[mhmmd_srf]

Hi All,

I am having an expression like Sum(DISTINCT SalesPlanned.).

Showing data against Month. Every Month level it is matching, but it is not matching in summary level. Similar Value we need to show in Single KPI.

If we actually calculate all the values of Month level it should come as 279413.6.

Can anyone please suggest.

Please help.

Thanks,

Sarif

[PrashantSangle]

Yes you solutions is correct.

Regards,

Prashant

[hemachandran]

HI try this expression,

=sum(aggr(sum(DISTINCT SalesPlanned),CstFiscalYearPeriodConcat))

[adamdavi3s]

You will note that this solution has already been posted above.

Please try and read the whole thread before commenting

[mhmmd_srf]

Yes Adam sir..you are correct.. looks like it is working..let me test it thoroughly..and will let u know..

Thanks a lot Adam sir.. for your kind help..

Thanks,

Sarif