2 Replies Latest reply: Oct 18, 2012 2:30 PM by whiteline _ RSS

    Help

    Ankit Modi

      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
          Mario De Stefano

          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

          • Re: Help
            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]))