Discussion Board for collaboration on QlikView Scripting.
I have a file, .csv, and in that I have blank fields, which I don't know why it seems to count them, and I would like that not to happen... Can someone tell me how to?
Now I am using only "count([Labor Rate])
Go to Solution.
Try the NumericCount() function.
it does look better now, but i am not entirely sure of it, i was using like this:
='US$' &' ' & round(sum(If([Labor Rate]*Rate<200,[Labor Rate]*Rate/V_Count_LRate,)),1.0)
this if part it was to exclude some wrong data... this V_Count_LRate was just =count(LaborRate). The answer was = 98,
now, it's 87... Before I was using the exact same numbers from a .xls, divided in 12 files (one for each month), now I am using a single .csv for the whole month...
what do you think it might have also changed?
Never mind, I found out what the problem was!