topic Re: Counting only numbers in QlikView

Counting only numbers

Thu, 30 Jan 2014 17:53:18 GMT

Hey guys,

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])

Re: Counting only numbers

Anonymous — Thu, 30 Jan 2014 17:55:14 GMT

Try the NumericCount() function.

Re: Counting only numbers

Thu, 30 Jan 2014 18:01:51 GMT

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...

Re: Counting only numbers

Thu, 30 Jan 2014 18:02:12 GMT

what do you think it might have also changed?

Re: Counting only numbers

Thu, 30 Jan 2014 18:11:39 GMT

Never mind, I found out what the problem was!