Discussion board where members can get started with Qlik Sense.
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.
Running QS 3.0
May be something like this
Dual(If(FieldName = Previous(FieldName), ' ', FieldName), AutoNumber(FieldName)) as DisplayFieldName
UPDATE: You might need to use Order By statement here
This is probably a bad example, but see if this makes sense
LOAD * Inline [
AutoNumber(Dim) as Temp2,
If(Dim = Previous(Dim), ' ', Dim) as Temp
Order By Dim;
DROP Tables Table;