1 Reply Latest reply: Oct 14, 2011 10:32 AM by Stefan Wühl RSS

    Error in Calculated Expression error when using Count and Only Functions

      Hello,

       

      I am new  to QlikView  and having an issue with trying to get a chart to work. I added an expression in the expression tab to represent the denominator of the calculation:

       

      Count(Only(MyField='Foo''))

       

       

      However I get an error in calculated expression message. Am I allowed to embed a one function inside another when creating an expression? Basically I am using this as a SQL where claus e as I need multiple charts based on values found in 'MyField'. Any help would be greatly appreciated! Thanks.....