Hide data that repeats

[rittermd]

In Qlikview you had a setting to hide data if it was repeating in a table and only show it one time.

For example I am displaying data for a therapist.  The Therapist name appears on every row.  I just want it to show on the first row and then show again for the next therapist on their first row of data.

I don't think this is possible in QS.

But I was hoping that someone might have a way to do this.

Thanks

Running QS 3.0

[sunny_talwar]

This you need in a chart? May be use Pivot table to do this?

[rittermd]

That was my first approach.  Unfortunately I have 4 dimensions and that is killing my server.  So I had to go back to a regular table instead.

[sunny_talwar]

May be create this in the script using Peek/Previous logic?

[rittermd]

Can you give me an example?

[sunny_talwar]

May be something like this

LOAD AllFields,

           Dual(If(FieldName = Previous(FieldName), ' ', FieldName), AutoNumber(FieldName)) as DisplayFieldName

FROM.....

UPDATE: You might need to use Order By statement here

[sunny_talwar]

This is probably a bad example, but see if this makes sense

Table:

LOAD * Inline [

Dim, Value

A, 10

A, 40

B, 20

B, 20

A, 30

D, 10

A, 10

];

FinalTable:

LOAD *,

  AutoNumber(Dim) as Temp2,

  If(Dim = Previous(Dim), ' ', Dim) as Temp

Resident Table

Order By Dim;

DROP Tables Table;