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

    Problem with "rank" and suppress null values



      I have a problem with my QVW in attached.




      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,