Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rittermd
Honored Contributor

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
Honored Contributor II

Re: Table Formatting Question

You can simulated a mesure

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

ecolomer
Honored Contributor II

Re: Table Formatting Question

Is that you need?

P_228285.png

rittermd
Honored Contributor

Re: Table Formatting Question

How did you make the pivot table look like that?

ecolomer
Honored Contributor II

Re: Table Formatting Question

I upload file

rittermd
Honored Contributor

Re: Table Formatting Question

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

ecolomer
Honored Contributor II

Re: Table Formatting Question

I'm sorry.

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

Community Browser