18 Replies Latest reply: Jul 7, 2015 6:02 AM by Stefan Wühl RSS

    Problem with "rank" and suppress null values

    Willy GARNIER

      Hello,

       

      I have a problem with my QVW in attached.

       

      Rank.jpg

       

      I have simplified the example and I cannot suppress the 0 values in the script (because qty are linked to a date and I filter the date using a calendar in the report).

       

      I have:

      - Item

      - Seller

      - Quantity

       

      I want to sum the quantities by Item and Seller and show the line ONLY if the sum of Qty is not equal to 0.

       

      It is OK with 3 columns (Item, Seller and sum of Qty), but if I add a rank column, the lines with null values appear (the suppress null values is checked).

       

       

      How can I suppress thes lines and keep my rank columns ?

       

       

      Thank you,

      Willy