Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This you need in a chart? May be use Pivot table to do this?
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.
May be create this in the script using Peek/Previous logic?
Can you give me an example?
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
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;