Show total in bar chart - QlikSense

[_armoco_]

How can I 'Show Total' in bar chart in QlikSense? I know currently its not an option in QlikSense, but is there a workaround?

[ogster1974]

I use the sub title section to insert any key totals I want to display to my users if that helps.

[Gysbert_Wassenaar]

You could create a new field in the script for your chart:

ReportDimension:

LOAD Distinct MyDim as ReportDim, MyDim Resident MyTable;

Concatenate(ReportDimension)

LOAD Distinct 'Total' as ReportDim, MyDim Resident MyTable;

Then you can use the new field ReportDim instead of MyDim as chart dimension.

[jagan]

Hi,

You have to create a new field as gwassenaar‌ suggested, then you can use the new field as dimension in your dimension.  If you want the same for other dimensions also repeat the same.

Hope this helps you.

Regards,

jagan.