How to Show NA in Resultant table in Qliksense if the table doesn't have data for given filters

[varaprasad0816]

Hi,

I have 3 tables in Qlik NPrinting Pixel perfect which are having 3 different filters with hard coded (SLA Type : Uptime, Resolution, Other)

I am passing airline code and date filter through report level, but some of the airline codes doesn't have the data in those three tables, hence i am getting error while previewing the data.

so, i tried with task level by passing these filters to get an Email with attachment but not getting even Email for those airline codes because which doesn't have the data in respective 3 tables.

But how come the end user get to know that respective airline code doesn't have data as he should not get an Email as well.

please let me know how can I achieve in NPrinting to get 'NA' report for these 3 tables through an Email.

Please find attached screenshot for your reference.

Regards,

Vara

[varaprasad0816]

Please find below data model script for your reference.

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/SQL/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 SLA_CarrierCode,
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/SQL/SLA_Commitments_ShData.QVD]
(qvd)

Where CreditCalculation = 'Each';

Table fields :

i. SLA_ServiceFunction

ii. SLA_UnplannedDowntimeMinutes

iii. SLA_ActualUptimePercent_New

iv. SLA_CreditDuePercent_New

v. SLA_NotesFunction

Regards,

Vara