topic Re: Help in QlikView

Help

Anonymous — Tue, 16 Oct 2012 12:59:35 GMT

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

Re: Help

Wed, 17 Oct 2012 15:45:35 GMT

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

Re: Help

whiteline — Thu, 18 Oct 2012 18:30:22 GMT

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]))