Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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