Discussion board where members can get started with Qlik Sense.
I have a simple one table query. When I include all 7 fields, I get about 60,000 rows.
When I remove one string field from the list, I get all 6,000,000+ rows.
There are 113 distinct values for this one field.
When I query with other tools, I get all 6,000,000+ rows regardless of the fields selected.
Tried moving the field to various positions in the list but still get 60,000 rows.
Anyone else experience a similar issue ?
Go to Solution.
There are a few options to resolve this issue. FYI - we have Sept 2018 version
Hope this helps
View solution in original post
I suggest you to use RowNo() as ID to get All rows. Because, Qlik always removes duplicate while reloading the application.
I know duplicates will not appear for a straight table but on the load ?
Qlik removes duplicates while reloading even if I don't specify DISTINCT ?