Could you please kindly assist me with the proper use of the "and" logical function in an expression. For example, I have tried using it as follows: Count(If(Year='2013'and [Estimate-Kg]>='0' and [Sales-Kg]<='1',[Grower No.],0)), this doesn't quite work. Is there also some sort of a "syntax" guide available?
Your expression will return a number different from what you want. You use
Count(If(Year='2013'and [Estimate-Kg]>='0' and [Sales-Kg]<='1',[Grower No.],0))
You have four fields inside the aggregation, fields that probably reside in different tables. The logic is that QlikView first creates the join between these tables, and then performs the count on this temporary table. I.e. the number of rows will be much larger than you want.
Your expression will return a number different from what you want. You use
Count(If(Year='2013'and [Estimate-Kg]>='0' and [Sales-Kg]<='1',[Grower No.],0))
You have four fields inside the aggregation, fields that probably reside in different tables. The logic is that QlikView first creates the join between these tables, and then performs the count on this temporary table. I.e. the number of rows will be much larger than you want.
Unfortunately it's returning a zero count. I have manually checked the data, and I have instances where I have estimated kg's, but no actual sales, i.e. sales-kg = 0,
.png "Former Employee"){kind=icon}