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!