Migrating from NPrinting to Cloud Reporting: need help with translating my set analysis from NPrinting into my script

[Rfoot]

Hi all,

We are moving away from OnPrem Nprinting and I have decided to create a new section in my script for reporting then I will send the table I create to a sharepoint folder and staff can access the CSV file whenever they please.

What I am having trouble with is translating my set analysis from NPrinting into my script to create some of my columns.

For example:

If I try translate the code below I fail everytime.

- num(SUM({_[CAL Fin Month]={'Jul'}_}[GL Actual]),'#,##0;(#,##0)')

Regards,

Ryan

[JonnyPoole]

You can use sum() in the load script, but it must be done with the GROUP BY clause which sets the aggregation granularity to one or more fields.  

https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/AggregationF...

Set Analysis can be replaced with an IF() statement in the load script:   

Something like:

If( Month='January',Sales,0)  as JanuarySales