delete repetition in my table

[#1]

I have a table with lots of repeated products and I do not want to show several equal, I want to show only one, but do not want to erase them from my table

example:

A

A

A

B

C

C

I want show only:

A

B

C

[#2]

Hi there, try using a pivot table instead. Switch to this graph in the general tab of the properties menu.

Regards

[johnw]

I'm a little confused. Combining like values is how QlikView normally behaves. You shouldn't see A A A B C C unless you include some other field that distinguishes between those rows, like a row ID.