Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

ankitd_modi
Contributor

Help

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 Replies
Not applicable

Re: Help

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
Honored Contributor II

Re: Help

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