Multiple lines in Pivot and Straight table cells in QlikSense

[vinieme12]

[Paragraph format. Descriptive text here. See Content Guidelines for details. You can remove sections that are not needed for your article. If subheaders are needed, use heading 3 or heading 4 formats.]

Description:

• By default Straight tables only allows maximum of 3 lines in a cell to be visible and Pivot tables are limited to one line only

Resolution

By using a Multi-KPI object we can inject custom CSS onto the sheet to override the default limitations on pivot & straight tables

Step1:

Drag a Multi-KPI object onto the sheet  and add a dummy measure example = 1;

Next, on the Properties panel of the Multi-Kpi object navigate to Appearance >> Styles

Add CSS here

Step2:

Paste the custom below

For Straight Tables add the below CSS snippet in the Styles(CSS) box

.qv-st .qv-st-value .qv-st-value-overflow {
max-height: none;
}

For Pivot Tables add the below CSS snippet in the Styles(CSS) box

.qv-pt .cell .value {
max-height: none;
white-space:pre
}

As shown below now each cell will fit to content of the cell based on line breaks in the content

Output

Cheers

Vineeth P

[Chotana2]

Hi Vineeth

Awesome!! Exactly what I was looking for for several days.

But the width of my columns are unknown, and I can't change it ; I have the horizontal scrollbar, but I can't change the width manualy

If I force the width like this :

.qv-pt .cell .value {
max-height: none;
white-space:pre;
width:250px
}

Then I do have a smaller cell, but I don't have several cells displayed , only one

Any thought?

Thanks

[Chotana2]

and it's chr(13) that's working for me in a pivot table

Concat(DISTINCT todo, chr(13))

[vinieme12]

Hi@Chotana2   ,

I'm unable to replicate your issue, can you post a sample app?

[Chotana2]

Hello @vinieme12 

Well finaly I used a Vizlib Pivot table, with option

'Text is HTML'

and

concat(DISTINCT tasks, '</BR>')

I don't understand why it was not working with your solution. Thanks anyway.