5 Replies Latest reply: Oct 15, 2012 7:38 AM by Jonathan Dienst RSS

    Urgent help

    Ankit Modi

      Hi,

       

      Please can any one help me, as in  QlikView 8.5  the below expression is working fine but same thing is not working in QlikView 11

       

       

      =COUNT(distinct if([ Stage Name]='Fund',ID&[Cycle Hierarchy Owner]))

       

       

       

      PN:- [Cycle Hierarchy Owner] - This is actualy the cyclic drill which is there in the dimension and we have used in the expression to group the data accordingly.

       

      It is working fine in Qlikview 8.5 version but when i use the same thing in Qlikview 11 version its given me the error " Bad field name [Cycle Hierarchy Owner]"

       

       

       

      Can any one help me on this..

       

       

      Regards,

      Ankit