Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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]))