Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Counting only numbers

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

1 Solution

Accepted Solutions

Re: Counting only numbers

Try the NumericCount() function.

4 Replies

Re: Counting only numbers

Try the NumericCount() function.

Not applicable

Re: Counting only numbers

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

Not applicable

Re: Counting only numbers

what do you think it might have also changed?

Not applicable

Re: Counting only numbers

Never mind, I found out what the problem was!

Community Browser