Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Column Profiling Chart

Hello Everyone!

Is it possible to have a column data profiling on one chart? What I am trying to do is give a summary on the columns data showing :

1- Count of DISTINCT values

2- Count of Duplicated Values

3- Count of NULL values

For example, say I have a column "DateofBirth", I'd like to have a bar chart (or pie chart) showing the above measures. Now I have applied the above measures but when it comes to selecting a dimension (since I have to select) it messes what I am trying to accomplish

Thanks & your feedback is really appreciated.

11 Replies
rubenmarin

Having all values of a dimension the count of duplicates can be:

Sum(Aggr(Count(AGE),AGE))

But I don't get how the nulls it should be counted having dimension values, or why count distinct.

rubenmarin

Or this attachment?

There are many options if I start to imagine what you want, and english is not my native language... a sample, or at least a screenshot of what behaviour you search will be nice.