topic Re: Easy Extract Information Density and Subset Ratio in QlikView

Easy Extract Information Density and Subset Ratio

Fri, 18 Sep 2015 12:51:44 GMT

Is there any way to simple extract the information density and subset ratio information for each column in each table in QV?

Re: Easy Extract Information Density and Subset Ratio

Anonymous — Fri, 18 Sep 2015 13:00:45 GMT

Please check the below link

Re: Chart with count of $Field values

Re: Easy Extract Information Density and Subset Ratio

satishkurra — Fri, 18 Sep 2015 13:03:35 GMT

There is no way we can extract the information from Table Viewer in Qlikview. It is just for viewing purpose.

But

We can write some expressions on the UI layer to get the Inf. Density and SS

Please see here

1. Load some data from file/DB

List box with expression as =[$(=minstring($Field))]

Label as

=minstring($Field)

3. Create Pivot Table with no dimension and expressions as

Label: Distinct Values

Expression: count(DISTINCT [$(=minstring($Field))])

Label: Null Values

Expression: sum(if(isnull( [$(=minstring($Field))]), 1, 0))

Thanks

Satish

Re: Easy Extract Information Density and Subset Ratio

Peter_Cammaert — Fri, 18 Sep 2015 13:18:31 GMT

I think there is no way to calculate Subset Ratio's using QV objects and dimensions/expressions. Those things typically make use of fields (all values thrown together) while a subset ratio tells you how many values appear in a field instance in a particular internal table.

Re: Easy Extract Information Density and Subset Ratio

Fri, 18 Sep 2015 14:51:49 GMT

Well guys thank you all for your help - all helpful answers, alas no possible way to extract that information as is. The only solution I came up with which was useful to a point was a straight table with $Fields as a dimension, and then have a couple of expressions which were count($Fields), count(DISTINCT $Fields) and then count(DISTINCT $Fields)/count($Fields) to show where fields held the same value which is some sort of information integrity measure rather than density. Thanks guys anyway, useful chat.

Re: Easy Extract Information Density and Subset Ratio

EquiBal — Sun, 08 Nov 2020 18:44:16 GMT

You are wrong.. this did not work. the expressions are base less and a waste of time.