Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE

Formatting for Totals in Straight / Pivot table.

SGV
Creator
Creator

Formatting for Totals in Straight / Pivot table.

Qlik,

It would be helpful if we have the ability to format the totals in straight table and pivot table. See the attached pic. 

SGV_0-1602524129306.png

 

@Patric_Nordstrom 

1 Comment
Patric_Nordstrom
Employee
Employee

Thank you all for your feedback on ways to improve our product. Do you mean to have different formatting on the total and the measure? Right now the total follows the measure format.

To customize the total, it's possible to use dimensionality:

=if(Dimensionality()=0,round(sum(Sales)),sum(Sales))

Will round the total but not the rows.

Thanks, 
Patric

Status changed to: Open - Collecting Feedback