9 Replies Latest reply: Dec 12, 2014 11:46 AM by Sarah Hymers RSS

    Dimension limits with negative values sorted in ascending order in bar chart

      Hi all!

       

      I have an issue with the tab "Dimension Limits". I want to show only the smallest 10 values in a bar chart. To do so, I mark the checkbox but than I get the error message "No data to display". When I chance to show only the largest 10 values it works correctly. I want all values to be sorted in ascending order by the y-value and I need to be sure that only negative value will be shown. The expression I use is something like this:

       

      IF

      (

      (

      CEIL(MAX(KeyFigure1)) +

      CEIL(AVG(KeyFigure2)) +

      CEIL(AVG(KeyFigure3)) -

      CEIL(AVG(KeyFigure4))

      ) < 0,

      CEIL(MAX(KeyFigure1)) +

      CEIL(AVG(KeyFigure2)) +

      CEIL(AVG(KeyFigure3)) -

      CEIL(AVG(KeyFigure4))

      )

       

       

      When I use the formula below it works, but in this case I can not be sure to take negative values into account only:

      CEIL(MAX(KeyFigure1)) +

      CEIL(AVG(KeyFigure2)) +

      CEIL(AVG(KeyFigure3)) -

      CEIL(AVG(KeyFigure4))

       

      Thanks in advance for any hint or help!

       

      FYI - I use QlikView version 11.0.11426.0 SR2 (x64).

       

      Cheers,

      Martin.