0 Replies Latest reply: Aug 18, 2015 10:40 PM by Tim Marsh RSS

    Table/KPI report: excluding certain records

    Tim Marsh

      Hi all,  (new to Qlik Cloud).

       

      I have a report view with a table, as well as KPI with one measure.

       

      In the table, I want to suppress certain rows (records).

       

      I can select on a row with 0 as cell values (ie hide rows with 0 in a certain cell/column) or rows with "-" (null).

       

      How can I force the table to suppress rows based on this requirement.

       

      Similarly I have a KPI report with one measure which counts cells if there is a value. However I want to do the same thing and prevent cells from being counted if they have a certain value, 0 or - (null?). This isn't an OR statement, I just can pick one or the other.

       

      Thanks for any help!

       

       

      Tim