Qlik Community

Qlik Sense App Development

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

rathnam_qv
Contributor

Count difference after loading data from Oracle

Hi All,

i am loading data from Oracle.

Actual Query Count is: 33009

Qlik also loading same count (33009) of records. But, i am finding different count (32348) after creating a Straight Table using those columns.

i am not able to find the issue?

can somebody let me know why it is behaving like this.

Thanks,

Muni.

1 Solution

Accepted Solutions
MVP
MVP

Re: Count difference after loading data from Oracle

The straight table will load distinct combinations of the dimensions. If you have more than one line with the same set of dimension value, the straight table will have less rows. You could create a unique key as outlined above.

6 Replies
shraddha_g
Honored Contributor III

Re: Count difference after loading data from Oracle

while loading field add rowno() using autogenerate and then see the max rowno

zhadrakas
Valued Contributor

Re: Count difference after loading data from Oracle

Hello,

is the field your are using the Count on a keyfield?

if yes, try to duplicate this field with a new Name and Count this field.

regards

tim

rathnam_qv
Contributor

Re: Count difference after loading data from Oracle

Hi TIM,

Thanks  for your Reply.

i checked the distinct count of key column it is matching with Database. But, overall count is not matching.

Thanks,

Muni.

MVP
MVP

Re: Count difference after loading data from Oracle

The straight table will load distinct combinations of the dimensions. If you have more than one line with the same set of dimension value, the straight table will have less rows. You could create a unique key as outlined above.

rathnam_qv
Contributor

Re: Count difference after loading data from Oracle

Hi Jonathan,

Thanks for your valuable time.

i am using the following

AUTONUMBER(TEXT(PO_NBR & '|' & PART_NBR & '|' & QTY)) AS KEY

is this leading to have less records?

Thanks,

Muni.

MVP
MVP

Re: Count difference after loading data from Oracle

That will have the same cardinality as the underlying values, so it will not add or remove any rows - providing the 3 underlying values are in the original table.