Help

[Anonymous]

Hi,

This expression is working fine in QlikView 8.5 but not in QlikView 11. Its giving error as Allocated exceeded memory.

COUNT(distinct IF(([Task Type]= 'Email' ) and not isnull([Acc Id]),[Event Id] & if([Classification Id] = SFDC.OWNERID,Tier,'Unclassified`')))

Please can any one help... Thanks in Advance...

Regards,

Ankit

[#2]

Try this:

=COUNT(distinct IF((only([Task Type])= 'Email' ) and not isnull(only([Acc Id])),only([Event Id]) & if(only([Classification Id]) = SFDC.OWNERID,Tier,'Unclassified')))

regards

MC

[whiteline]

Try something like this:

COUNT(distinct aggr(IF(([Task Type]= 'Email' ) and not isnull([Acc Id]),[Event Id] & if([Classification Id] = SFDC.OWNERID,Tier,'Unclassified`')), [Event Id], [Acc Id], [Classification Id]))