Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
varaprasad0816
Creator II
Creator II

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);

 

Regards,

Vara

 

Labels (1)
0 Replies