Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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???
Only I Can see 'Total' bar on the bar chart and sum is correct.
But I need all bars with total
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] ;
Wow
Great Sharddha
This is working
Thank You So much
Awesome!