Total Bar in Bar chart in Qlik Sense

[Shahzad_Ahsan]

Hi Everyone

This is qlikview snapshot

I want 'Total' bar in the bottom, which shows the sum of all the bars.

Is this possible in Qliksense???

[Shahzad_Ahsan]

Only I Can see 'Total' bar on the bar chart and sum is correct.

But I need all bars with total

[shraddha_g · Accepted solution]

Try:

[KAMC_EAM_ORDERS_BIO_MEDICAL]:

Load *,

     [STATUS_USER] as NewStatus;
Load
WIP_ENTITY_ID,
WIP_ENTITY_NAME As [WO Number],
if(ORGANIZATION_ID=1,'Bio Medical','General Maintenance') as [Organization],
if(PLAN_MAINTENANCE='Y','Preventive','Corrective') as [WO TYPE],
ASSET_GROUP,
STATUS,

if (STATUS = 'Unreleased','Open',
if(STATUS='Draft','Open',
if(STATUS='Complete - No Charges','Complete',
if (STATUS='On Hold','In Progress',
if(STATUS='Released','In Progress',

STATUS))))) as [STATUS_USER],
if(STATUS = 'Unreleased',1,
if(STATUS='Draft',1,
if(STATUS='Complete - No Charges',4,
if(STATUS='On Hold',3,
if(STATUS='Released',3,
if(STATUS='Cancelled',2,
if(STATUS='Closed',5,
if(STATUS='Complete',4,
STATUS)))))))) as [STATUS_USER_ORDER],

DESCRIPTION AS [WO Description],
START_DATE,
year(START_DATE) as [WO Year],
month(START_DATE) as [WO Month],
DATE_CLOSED,
year(DATE_CLOSED) as [WO Closed Year],
month(DATE_CLOSED) as [WO Closed Month];

SQL
Select * from KAMC_EAM_WORK_ORDER_DETAILS where organization_id = 112;

Noconcatenate

NewTable:

Load *,

     [STATUS_USER] as NewStatus

Resident [KAMC_EAM_ORDERS_BIO_MEDICAL] ;

concatenate (NewTable)

Load *,

'Total' as NewStatus

Resident [KAMC_EAM_ORDERS_BIO_MEDICAL] ;

Drop table [KAMC_EAM_ORDERS_BIO_MEDICAL] ;

[Shahzad_Ahsan]

Wow

Great Sharddha

This is working

Thank You So much

[shraddha_g]

Awesome!