How to show 'NA' for No data information tables in Nprinting Via Qliksense
Hi,
I selected the 3 airline codes as an example (AR, AS, and TK)
I am trying to achieve if SLA Type = Resolution, the table should display NA for all the columns in the table.
I try to display the view on the Nprinting report to show every SLA Type and any of them doesn’t fulfill by the airline code/SLA month, I want to show NA instead of just blank.
I need to assign NA not to just one field but all the fields that I want to show on the NPrinting table Via Qliksense.
Please find below Load script and help me out .
SLA_DB:
LOAD SLA_DataMonth, SLA_Year, Carrier as Account_Name, //if(ISNULL(Rate),1,Rate) as Rate //if(IsNull(ServiceFunction), 'NA', ServiceFunction) as SLA_ServiceFunction, ServiceFunction as SLA_ServiceFunction, ActualUptimePercent as SLA_ActualUptimePercent, Num(ActualUptimePercent) as SLA_ActualUptimePercent_New, UnplannedDowntimeMinutes as SLA_UnplannedDowntimeMinutes, CreditDuePercent as SLA_CreditDuePercent, Num(CreditDuePercent) as SLA_CreditDuePercent_New, NotesFunction as SLA_NotesFunction FROM [lib://AS Business Operations - QVD/SharePoint Data/SLA_DB_ShData.QVD] (qvd);
//Where ActualUptimePercent < '100.00%' and Not Match(ActualUptimePercent,'-');
Join
SLA_Commitments:
LOAD //Airline as SLA_Carrier, Airline as Account_Name, CarrierCode as Airline_IATA_Code, ProductSuite as Ptot_ProductSuite, SLAType as Ptot_SLAType, //If(IsNull(SystemName), 'NA', SystemName) as SLA_ServiceFunction, SystemName as SLA_ServiceFunction, CommittedUptimePercent as SLA_CommittedUptimePercent, Num(CommittedUptimePercent) as SLA_CommittedUptimePercent_New, CreditCalculation as Ptot_CreditCalculation FROM [lib://AS Business Operations - QVD/SharePoint Data/SLA_Commitments_ShData.QVD] (qvd);