Distinct Field Value in Straight Table

[qlikwiz123]

Hi,

How do I display Distinct Values of a Field in a chart, like a Straight Table? I know List boxes etc show Distinct values but this is not the case in Tables. I don't want to use Distinct in Load since I need the Field values for other charts.

Current Data:

File Name     Ver

FileA               1

FileB               1

FileA               2

Expected Output

File Name     Ver

FileB               1

FileA               2

I need to show Unique File Names based on the Maximum Ver number available for them.

[vishsaggi · Accepted solution]

Just use Max(Ver) in your expr.

Dim: Filename

Expr: Max(Ver)

[qlikwiz123]

Thank you so much Vishwarath