I'm running a report with Enable Cycle option in Qlik N-Printing, So my resulting spreadsheet comes with all the stakeholders who are Paying. which is fine my question here I would like to add another Cycle option is Receiving for only 1 bank in the same report, how could I able to do that. I don't want to produce two separate Excel Spreadsheets.
My end result would be Paying = all banks and receiving only 1 bank. would you please guide me a solution or any if statement would resolve my issues
Currently we are producing reports from QlikSense and NPrinting
We have two columns 1. Paying 2. Receiving which I'm using in Cycle option Paying = Barclays, City, HSBC, JPMorgan,Goldman Receiving = UBS, RBC, HSBC, CityGroup