Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

suhaibani_f
New Contributor II

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

Re: Column Profiling Chart

Hi feras, and what you try to accomplish? if you want to ignore all selections you can add {1} to expressions:

Count({1} FieldName)

suhaibani_f
New Contributor II

Re: Column Profiling Chart

Hi Ruben, thanks for your reply. I am not trying to ignore all selections, Say I have column Age which has the following values:

NULL

NULL

54

53

55

55

23

23

20

20

I would like to have a ONE chart that represent the following:

Duplicates Count: 3

Distinct count: 5

Null count: 2

Re: Column Profiling Chart

Maybe?...

Duplicates Count:

Sum(Aggr(If(Count(Age)>1, 1),Age))

Distinct count:

Count(DISTINCT Age)

Null count:

Sum(If(IsNull(Age), 1, 0))

suhaibani_f
New Contributor II

Re: Column Profiling Chart

That's fantastic; however, I am still facing the same issue, in case of a bar chart if the dimension is AGE then it will count the above measures based on that dimension. What I am trying to accomplish is that above measures in total (without going into detail)

Re: Column Profiling Chart

Can you upload a sample to check?

suhaibani_f
New Contributor II

Re: Column Profiling Chart

OK....

the table is:

CustomerID,   AGE

1               ,       NULL

2               ,       NULL

3               ,       55

4               ,       55

5               ,       53

6               ,       52

7               ,       20

8               ,       20


How can I have a bar chart to display the above data as follows:


3 BARs

BAR1: 2 // NULLS

BAR2: 4// DISTINCT Values

BAR3: 2 //DUPLICATES



Hope it is clear now.

Re: Column Profiling Chart

PFA, you can see the 3 bars with the expressions I posted before.

suhaibani_f
New Contributor II

Re: Column Profiling Chart

I do have to select a dimension, don't I? if I Select age as the BAR chart's demsnion this will cause the chart to show the measures you wrote based on every single value... Which is not what I want.

Re: Column Profiling Chart

Hi feras, this is why I'm asking for a sample or a detailed step of what you want, What means "Select Age as bar chart dimension"?

Setting all values of AGE and make the expressions for all the values? the count distinct will be always '1', what else should count?

Community Browser