Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am loading data from a table, using ID as unique identifier.
If I build a pivot table with all the columns from my source but not including [ID] all my data is grouped by all the other columns, so in the end I get less rows than the real number just because I don't have [ID] as a column in my pivot table.
However, I want to see all rows (even if the data is the same in all the other columns), so I would like to avoid Qlikview aggregating my data.
I don't have any calculations in my pivot table, I just want to show all rows without having to include [ID] in my table.
Thank you
Instead of this ID you may create another one with recno() or rowno() within the script and use them within the table.
- Marcus
there is no other way to enable the table to show me all duplicates without having to add another field? I really need to keep the table as it is
No, there is no other way to display all records respectively combinations of field-values. This behaviour was intentionally designed within the Qlik architecture and is one of the key-features - means not storing each field-value of each record like a database or like it happens within a csv else only distinct field-values are stored. This lead to the effect that each object showed only distinct records / field-value combinations. It's really a benefit.
If including of such an ID is really a big problem you may include these information within another extra field, for example with something like:
date(Date + rowno() / 10000000) as DateSpecial
This date is now of course not a real date anymore else a timestamp but it will be further displayed within the table as date. By exporting this table to Excel or a csv it could cause trouble - but this depends on the exact scenario.
- Marcus