#70 🎯 Data Quality fields in Qlik Sense - 1 Missing values
Helps users to fix data quality in your dashboard. 🕳 Handling missing data in Qlik Sense
Data quality is at the heart of all our projects and can really be a pain point at some times.
Should you wait for perfect data? I think no.
In the first release, start talking about quality, inform and help people correct missing data.
Don't wait until your data is perfect before you start publishing your indicators. But warns about errors that need to be corrected to make the whole thing more reliable.
In this example, I’m dealing with missing data, which you should of course treat and not leave as is in your data model.
Some dates and kilometers are missing. I don’t have any formatting issue on Buying Date since the software records it well, but it may be missing.
I used to create several fields to deal with it :
A technical flag to be used in Set Analysis
A Yes or No field for filtering
A visual ❌ or ✅ to display and filter as well
Load Script sample :
if(len("Buying Date")=0,0,1) as Flag_Date, if(len("Buying Date")=0,'No','Yes') as "Buying Date filled ?", if(len("Buying Date")=0,'❌','✅') as "Buying Date Control",Data quality is a vast subject and I will certainly talk about it in future posts!
What are your tricks to handle missing data?
