Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
rittermd
Not applicable

Hide data that repeats

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

6 Replies
sunny_talwar
Not applicable

Re: Hide data that repeats

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

rittermd
Not applicable

Re: Hide data that repeats

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
Not applicable

Re: Hide data that repeats

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

rittermd
Not applicable

Re: Hide data that repeats

Can you give me an example?

sunny_talwar
Not applicable

Re: Hide data that repeats

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
Not applicable

Re: Hide data that repeats

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;

Capture.PNG