I'm struggeling to understand what I'm doing wrong here.
I have a table with Brokers and prices (and more columns, but that is not of relevance). When I set up a chart table to count how many rows that have Price = 0 per broker, I have tried the following expressions:
=sum(if(Price=0, 1,0)) <--- Does work
=count({1<Price={"<0.00001"}>} Broker) <-- Does work
=count({1<Price={0}>} Broker) <---- Doesn't work
What I find amazing is that when I use set analysis, I can't compare with 0, even though the data in the table is 0. I have to compare it with extremly small number. When I use the fist expression listed above, I can successfully compare it with zero.
I found this text from QV11 tutorial, and after going through this discussion i am bit confused whether 0,0.001,0.1 for all which numeric equivalent is 0.
Data storage inside QlikView
In order to understand data interpretation and number formatting in
QlikView, it is necessary to know how data is stored internally by the program.
All of the data loaded into QlikView is stored in two representations,
as a string and as a number.
1 The string representation is always available and is what is shown in
the list boxes and the other sheet objects. Formatting of data in list
boxes (number format) only affects the string representation.
2 The number representation is only available when the data can be
interpreted as a valid number. The number representation is used for
all numeric calculations and for numeric sorting.
If several data items read into one field have the same number representation,
they will all be treated as the same value and will all share the first
string representation encountered. Example: The numbers 1.0, 1 and 1.000
read in that order will all have the number representation 1 and the initial
