topic Re: Cycling reports in Qlik NPrinting

Cycling reports

happyfeet11 — Fri, 25 Sep 2020 12:45:04 GMT

Hallo All

Need urgent help in the genearting a report and Sending it per email.

i have a qliksense app with a table and five columns : A,B,C, D,E.

i would like to do the following .

report Name : ABC.pdf

and cycle per Field A, B and C

I try to use the cycling option but even after 3 hrs it Fails to generate a report and the server stands still.

Kindly help

Its very urgent.

Best Indrani

Re: Cycling reports

robert_mika — Fri, 25 Sep 2020 12:55:33 GMT

How many values do you have per column?

If you have applied all 3 dimensions (A,B,C) as cycle the NP is looping thru all the columns.

Taking A1,B1,C1

A1,B1,C2,

......

where 1,2 are values in the columns

Re: Cycling reports

happyfeet11 — Sat, 26 Sep 2020 11:52:20 GMT

Hi Robert

there are about 150 rows per column. ist a dynamic app and evenytually the report would also be dynamic .

I understand your logic. but i really Need the report with there three infos as A, B and C are unique per row. so filtering will not working.

i actually once did cycling based on order goup and Customer id and it worked very smoothly. i am wondering why isnt it working this time.

Re: Cycling reports

robert_mika — Sat, 26 Sep 2020 15:13:54 GMT

Do you really need 3.75M reports?

Not about your data model (you can share it) but maybe a solution is to concatenate those dimensions and then loop thru it?

Re: Cycling reports

happyfeet11 — Sun, 27 Sep 2020 07:31:29 GMT

thanks a lot Robert. i am going to try it right now

Re: Cycling reports

happyfeet11 — Sun, 27 Sep 2020 20:02:08 GMT

Hi Robert tried concatenating the dimensionsA B and C. now i have three columsn DAte, result and ABC. still cycling per ABC with 150 datapoints would make the system slow. any solutions please

TIA

Re: Cycling reports

Ruggero_Piccoli — Mon, 28 Sep 2020 09:04:46 GMT

Hi,

In Qlik NPrinting terminology cycling means to create a different file for each combination of the fields configured in the cycling settings. It is explained in https://help.qlik.com/en-US/nprinting/September2020/Content/NPrinting/ReportsDevelopment/Cycling-your-reports.htm.

Your request has a very short description and it is not clear to me. Do you want to create a different file for each combination of the fields? Or what is your goal?

If you are a customer and you have an urgent request, please consider also to open a support ticket. This is a community of volunteers so we cannot warranty a specific response time as we did with the support service.

I also strongly suggest you to start by studying the Qlik NPrinting official help site. This will give you the correct terminology and the skills to create the templates you need.

Best Regards,

Ruggero