topic Re: How to add calculated fields using if condition in excel report with the available fields in Np in Qlik NPrinting

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

Garima2020 — Tue, 15 Sep 2020 07:54:13 GMT

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.

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

Ruggero_Piccoli — Wed, 16 Sep 2020 09:30:23 GMT

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