How to add calculated fields using if condition in excel report with the available fields in Np?

[Garima2020]

I am migrating some of my hyperion reports in qlik. So I am referring sql of these reports  to implement Nprinting reports, here I have this condition to implement in my Npritning excel report

CASE
WHEN AL1.Field1 = 'ABC'
THEN AL1.Field2
ELSE 'XYZ LTD.'

WHERE TABLE1  AL1

So this case condition would be a different column in my excel report, Could someone please suggest a way to implement it?

Thanking in anticipation.

[Ruggero_Piccoli]

Hi,

I would like to suggest you to give a look at the online help site where it explains how to develop Excel reports at https://help.qlik.com/en-US/nprinting/April2020/Content/NPrinting/ExcelReports/Intro-Excel.htm.

For example you can use Excel formulas to add calculated fields on the generated reports. So you could add the condition in those Excel formulas.

Best Regards,

Ruggero