Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
h2bi
Partner - Contributor III
Partner - Contributor III

Skipping records with similar values

Hello, Qlik is skipping some records that containes same values in some columns

For example i have a record with 4 columns Date, Amount, Nationality, Type, Order Nº

In the table i have 3 records :

08/01/24, 5, British, Card, 2736

08/01/24, 5, British, Card, 7564

08/01/24, 5, British, Card, 9083

In the table records when there is the same nationality and amount Qlik keeps the first record and skips the others does not show them

P.S: i did some mappings and joins in the data model

 

Labels (2)
1 Reply
Or
MVP
MVP

Qlik does not "skip" records. A table object shows one row for each unique combination of dimensions by design (otherwise, you would not be able to aggregate for these dimensions). If you'd like to show individual rows, add the order number as a dimension in your table, or another dimension that would make for a unique combination.