topic Re: Calculate Duplicate values in QlikView

Calculate Duplicate values

Tue, 22 Apr 2014 20:37:55 GMT

Hello Experts,

I have some values and it is repeated many times in the source data but when i read this in the qlikview, then i get only 4 values how this occurs. I have this types

Raxle-Rec
adghj
adghj
adghj
adghj
adghj
adghj
athed
athed
athed
athed
hytrew
hytrew
hytrew
edvfg
edvfg
edvfg

Thanks

Re: Calculate Duplicate values

its_anandrjs — Tue, 22 Apr 2014 20:42:00 GMT

In qlikview when you read the fields if there is same records it will show single value if it is not associated with any value or field. Also if you count the field you get its count result.

like see the difference in the script results

Count(Raxle-Rec)

Count(Distinct Raxle-Rec)

Re: Calculate Duplicate values

maxgro — Tue, 22 Apr 2014 20:43:55 GMT

check in table viewer (ctrl-t) if the number is correct

Re: Calculate Duplicate values

pgrenier — Tue, 22 Apr 2014 20:45:12 GMT

Hello Emily.

All records are still there, simply QlikView only shows you the diffrent values in list objects or charts.

If you wish, you can try creating a Straight Table chart using Raxle-Rec as dimension and Count([Raxle-Rec]) as expression.

Please find example file attached,

Regards,

Philippe

Re: Calculate Duplicate values

Tue, 22 Apr 2014 20:48:00 GMT

Thanks and how i count this values.

Re: Calculate Duplicate values

its_anandrjs — Tue, 22 Apr 2014 20:48:52 GMT

Load your table like below

LOAD * INLINE [

Raxle-Rec

adghj

athed

hytrew

edvfg

];

LOAD

[Raxle-Rec],

Count([Raxle-Rec]) as RCount

Resident T

Group By [Raxle-Rec];

And plot values in any table box

Re: Calculate Duplicate values

Tue, 22 Apr 2014 20:53:00 GMT

When i Press Ctrl + T and on table what is mean for the Information density, Tags: $ascii, $text.

Explain about this please.

Thanks

Re: Calculate Duplicate values

maxgro — Tue, 22 Apr 2014 21:35:51 GMT

from online help

When hovering with the cursor above one of the fields in a table, a tool tip pops up with information about the content of this field:

Information density is the number of records that have values (i.e. not NULL) in this field as compared to the total number of records in the table.
Subset ratio is the number of distinct values of this field found in this table as compared to the total number of distinct values of this field (that is other tables as well).
Table comments are displayed in the tool tip.
Field comments are displayed in the tool tip.
Tags that are added in the script or in Document Properties: Tables page, including system tags, are displayed in the tool tip.

or also

information density and subset ratio? What is the use of this?