Function Handling

[Midastouch365]

I am creating a KPI measure in Qlik Sense, and I am having trouble writing a function that counts the total number of null and not null files. 

So far, my code looks like this: Count(SourceFile)

But I want it to count all sourcefile, whether present or not present.

Could someone please guide me?

[Or · Accepted solution]

Count(coalesce(SourceFile,1)) should probably do it here. It'd be advisable to instead count a different field from the same table as SourceFile, though, which doesn't have null values. What's being counted is the number of rows with a non-null value, so it doesn't really matter if you count the SourceFile field or another field from the same table.

[Midastouch365]

Thank you for this! This is really helpful. I ended up counting a different field instead based on your suggestion and it worked. However, Count(coalesce(SourceFile,1)) didn't give me the correct value that I was looking for.

[vikasmahajan]

Hello,

While loading data you can check nulls see below post

https://data-flair.training/blogs/qlik-sense-null-functions/

If(len(trim(Value))= 0 or Value='NULL' or Value='-', Null(), Value ) as ValueNullConv;

use this flags in set analysis to avoid null values

Regards

Vikas