Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table that will have multiple rows for the same activity date. I only want to display the activity date on the first row and not repeat it on each row that follows. Then display it again when it changes.
There was a setting in QlikView to do this. I don't see anything in Qlik Sense. If there is not a setting I was hoping that someone would have a work around.
Example:
07/01/2016 John Doe PT
Mary Doe OT
Steve Smith ST
07/02/2016 Tom Jones PT
Sue Jones OT
07/03/2016 Mark Thomas PT
etc.
I don't think that I can use a Pivot Table for this because I have no measures in this table and don't need any. It appears that a Pivot table requires at least one measure.
You can simulated a mesure
Par example ' ' or 1 and put the color = with()
Is that you need?
How did you make the pivot table look like that?
I upload file
I am trying to do this in Qlik Sense. I don't have the same options that I have in Qlik View.
I'm sorry.
For Sense, I try similar solution. I try ....