Can we use qlik syntax in custom element in dynamic naming for reports >

[Siddhesh]

Hi,

I am using Qlik Nprinting May 2021 SR4 version. In reports, we have the option for dynamic naming. In my app, I have the variable name 'vReportMonth' which stores the month as an integer that I want to convert into a full month name if the variable has 1 in it I want January to display in the report name.

Can any one help me this.

[Lech_Miszkiewicz]

Hi,

No - variables are the only way at the moment. You need to create another variable say 'vReportMonthName' in QlikView or Qlik Sense with the full month name and reference that when building dynamic name.

cheers

Lech

[Ruggero_Piccoli]

Hi,

You can use variables in dynamic naming:

Create it with normal Qlik functions and force the output to be text with text(). 

Best Regards,

Ruggero

[Siddhesh]

Hi Ruggero,

In my case, the variable is having month number. I want full month name. 

[Ruggero_Piccoli]

Hi,

So you need help in writing a formula to get the text name of the month. The solution depends on the fields you have in the Qlik Sense app or QlikView document and we do not know your data structure.

I suggest you to start by checking the related help site where data and time functions are explained in details with examples (https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...).

You could also search in the community related to QlikView or Qlik Sense because I think it is a common topic there. 

Best Regards,

Ruggero

[Lech_Miszkiewicz]

note that Month() function is a dual so: 

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/DateAnd...

num(Month(some date)) will give you number

text(Month(some date)) will give you month name in format specified in your Qlik sense load script of the app .