Sub Total In the Excel

Qalyptus Cloud
#1

How to bold and format Sub Total and Total? or Is possible to generate Total?

#2

Hi Haja,
Welcome to the Qalyptus community.

Unfortunately, the Qlik Sense API does not support exporting the table formatting.

You should format your table in the Excel template file using conditional formatting. You can learn more here.

Below is an example of using Conditional formatting to add a background color to the total rows.

I add two formulas; the first one is for columns C, D, and E. We verify if the cell in column 3 (C) contains “Totals”; if so, we apply the Yellow color.

The second one is for columns B, C, D, and E. We verify if the cell in column 2 (B) contains “Totals”; if so, we apply the Yellow color.

image
image828×415 102 KB

image
image668×807 138 KB

Please let me know if you have any questions.

Thanks,
Lotfi