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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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