Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
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.
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