Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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

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.