For example, I have 13 records, 5 are zero (contents = "0") and 8 non zero. I am not sure if the 0 is a number or text string, but the data was imported from Excel and was a number format, value 0, in excel.
So, what what expression would I use to count non zero?
(Am new to Qlik).
I have the below, but it's counting every instance.
I have this in the Expression field in the Data section of the report element.
Thanks for helping with such a simple question. I googled an answer first, but couldn't find anything.