Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rittermd
Master
Master

Table Formatting Question

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.

6 Replies
ecolomer
Master II
Master II

You can simulated a mesure

Par example ' ' or 1 and put the color = with()

ecolomer
Master II
Master II

Is that you need?

P_228285.png

rittermd
Master
Master
Author

How did you make the pivot table look like that?

ecolomer
Master II
Master II

I upload file

rittermd
Master
Master
Author

I am trying to do this in Qlik Sense.  I don't have the same options that I have in Qlik View.

ecolomer
Master II
Master II

I'm sorry.

For Sense, I try similar solution. I try ....