identical records grouped on QlikView

[#1]

launch a query on the database and I get three identical lines

es:

mario      rossi

563214

mario      rossi	563214
mario      rossi	563214

If I run the same on QlikView I get only one

mario rossi 563214

Why?

[jpenuliar]

Do you experience that in a Table Box object?

See below:

Table box Rows does not match Charts/expressions/statistics aggregates

[#3]

The problem is that the execution of a query on a dbms and QlikView pointing at the same, generate different results.

This is not possible.

[jpenuliar]

Can you confirm from your Data Model(Table viewer), you have number of Rows = to dbms query result?

[Anonymous]

It is because they are identical, Qlikview will have loaded the three lines but will only display one. To show this you can select "Show Frequency" in the listbox. This should display 3 for each field. You can also use the expression count([your fieldname]) and count(Distinct [your fieldname]), this should return 3 resp 1.

[maxgro]

same:

load * inline [

field1, field2

1,a

1,a

1,a

];