i am rather suprised to realize that Qlik does not load completly identical rows of an excel sheet as multiple entrys into the resulting table. In my usecase (accounting) it is very likley that some accounting records are completly identical.
I already consulted the qlik help site, but found nothing regarding this topic.
The following Load Script contains a total of 4 entrys, with two identical ones (Auftrag 3). But the resulting table in qlik sense only contains the doublette once:
But to understand the logic of qlik better i would like to know if it is also possible to get these records into qlik without making them distinct in any kind.
Hi, with your first table you can add an expression with Count(Auftrag), if it returns 4 it means that all rows have been loaded.
If you crete a table and set all fields as dimensions you will see only 3 rows because each combination of dimensions only shows once. i.e. if you have Auftrag and Datum as dimensionand Sum(Wert) as expression you only see 3 rows but for Aufrag=3 the sum of Wert will be 5817,16.
If you want a table that only shows all records, without any operation, yes, you need to add a field that is different.
If you put your data in a qlik's table it won't show the duplicate row BUT it's there stored in memory. I mean, if you count your rowns you'll have 4 rows and with count distinct you'll have 3
