Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

_armoco_
Contributor II

Show total in bar chart - QlikSense

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

Tags (2)
3 Replies
ogster1974
Honored Contributor II

Re: Show total in bar chart - QlikSense

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

Re: Show total in bar chart - QlikSense

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.


talk is cheap, supply exceeds demand
MVP
MVP

Re: Show total in bar chart - QlikSense

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.

Community Browser