Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.