topic Re: Dynamic Report Name -Remove Cycle field variable in Dynamic name list (Nprinting Nov 2020) in Qlik NPrinting

Dynamic Report Name -Remove Cycle field variable in Dynamic name list (Nprinting Nov 2020)

prathapg1959 — Mon, 16 Aug 2021 11:23:06 GMT

Hi Team,

I am not able to remove cycle field value populating in Dynamic report name .Please suggest to remove cycle field value from dynamic report name.

Ex :

Sl.No	PRODID	PRODNAME	SALES
1	P01	Laptop	60000
2	P02	Printer	20000
3	P03	Scanner	30000

Cycle field is 'PROD ID' and Dynamic Report name field is 'PRODNAME'. When I generate the reports, Getting report filename as 'P01-Laptop.xls' but expected output is 'Laptop.xls'. Please find below screenshot. Please suggest to remove highlighted default cycle field variable in Dynamic name.

Re: Dynamic Report Name -Remove Cycle field variable in Dynamic name list (Nprinting Nov 2020)

Frank_S — Mon, 16 Aug 2021 16:44:55 GMT

@prathapg1959

Try this...

In the 'field to cycle' drop down, select 'Product Name' from the drop down rather than product ID.
Remove the Product Name variable from the Dynamic Name.

Re: Dynamic Report Name -Remove Cycle field variable in Dynamic name list (Nprinting Nov 2020)

Lech_Miszkiewicz — Mon, 16 Aug 2021 21:20:23 GMT

Obviously you are using ID to ensure unique values as Product names may not be unique. In such case I would try to load Product Name as dual with the numeric value being ID into your data model and follow by Franks suggestion which is correct and only solution at the moment!

cheers

Re: Dynamic Report Name -Remove Cycle field variable in Dynamic name list (Nprinting Nov 2020)

prathapg1959 — Sun, 22 Aug 2021 15:17:45 GMT

Hi Team,

Thanks for your suggestions. It is resolved.