Discussion Board for collaboration related to QlikView App Development.
I need your help in a issue. Explain me:
I have a table with duplicate rows:
In this example, I must show only one row, but show three for fields indicated in red. The correct output is:
I need assign null value to the fields indicated when find rows duplicated for this fields and update the number of rows.
Any idea? Thanks.
Because, you have different equipo, description, marca and modelo values.
Try to use Table box for that
.... and what for do you need then the fields "marca" and "modelo"?
what is supposed to happen, if there are different fieldcontents in the other fields?
anyway and with aircode:
LOAD DISTINCT Field1, Field2, Field2....., NULL() as marca, NULL() as modelo FROM ....;
So the client wishes...
Your LOAD not works but the table have 6500 rows, when someone is a unique row and others are few rows duplicates. In your LOAD can´t filter by equals dynamic fields.
Can you provide excel