topic Re: Label name Dynamic in Qlik NPrinting

Label name Dynamic

Chanty4u — Wed, 15 Nov 2017 07:29:46 GMT

Hi all,

lech_miszkiewicz

i Qliksense Nprinting am using the dynamic labeling for excel reports

i have a customer group with 40 customers so i created variable

vCustomerGroup=only(CustomerGroup)

if i use this in Np the report name also coming as

adithyacustomer_only(customergroup) like this coming for all customers. how to overcome this?

Re: Label name Dynamic

arvind_patil — Wed, 15 Nov 2017 07:34:32 GMT

Hi Chanty,

What will be output you require . What value in It.

Thanks,

Arvind Patil

Re: Label name Dynamic

Chanty4u — Wed, 15 Nov 2017 07:52:42 GMT

i need filename with the customergroup name in that field i have 40 values[means 40 customers are available so each report name with each customer]

Re: Label name Dynamic

Lech_Miszkiewicz — Wed, 15 Nov 2017 09:42:17 GMT

Hi,

I understand that in Qlik Sense this variable returns the expected value and in NPrinting it simply does not evaluate.

please correct if i am wrong and also let me test it tomorrow.

regards

Lech

Re: Label name Dynamic

Chanty4u — Wed, 15 Nov 2017 09:53:32 GMT

yes lech exactly.

in qliksense its working but not in Np

how to overcome this?

Re: Label name Dynamic

Chanty4u — Thu, 16 Nov 2017 05:57:14 GMT

Hi Lech Miszkiewicz

any update on this?

Re: Label name Dynamic

Lech_Miszkiewicz — Thu, 16 Nov 2017 05:59:58 GMT

nope ... testing... give me 0.5 hour

Re: Label name Dynamic

Chanty4u — Thu, 16 Nov 2017 06:04:21 GMT

Okay Lech,

thanks

Re: Label name Dynamic

Lech_Miszkiewicz — Thu, 16 Nov 2017 06:36:08 GMT

Ok.. here are my findings

Environments:

Windows 10 (my laptop)
Qlik Sense November 2017 Server
NPrinting November 2017

I did Following:

Created variable in my app (using field "Miesiac")
- variable definition: =Only (Miesiac)
I have regenerated metadata in NPrinitng
created a XLS report
- with Level Miesiac
- put my variable into Level
- also put my variable outside the level
- run preview and observe results
Results are on first 4 screenshots
- variable returns value only inside a level as only there it can be evaluated (=Only()) requires single value to evaluate!! - I am sure you know this
- variable sitting outside of the level instead of value brings its definition
Last step i did was also include "Miesiac" as a cyclic dimension and run task to publish report with variable as part of the file name
- task returned with expected values (each file had a dedicated value - also see screenshot 5)

In other words: WORKS FOR ME

cheers

Lech

Re: Label name Dynamic

Chanty4u — Thu, 16 Nov 2017 06:51:57 GMT

thanks lech,

am not using levels

am using custom template with all pivot tables that template am scheduling to 40 customers.

Re: Label name Dynamic

Lech_Miszkiewicz — Thu, 16 Nov 2017 06:59:34 GMT

Hi ,

the reason i put it into level was to make sure that at that moment there is only one value selected for the field used in my =Only(Miesiac) variable formula.

You can give a try, by changing a variable definition to =Concat(Disitinc YourField),

If this works, then it means that something is not right with values and your "=Only()" formula cannot be evaluated

regards

Lech

Re: Label name Dynamic

Chanty4u — Thu, 16 Nov 2017 07:01:12 GMT

Ok lech,

let me try and update you on the same

Re: Label name Dynamic

Lech_Miszkiewicz — Fri, 17 Nov 2017 05:39:35 GMT

hey, how did you go? any news re-this? I am curious to know.

cheers

Lech

Re: Label name Dynamic

Chanty4u — Fri, 17 Nov 2017 07:33:41 GMT

Here is the server down from two days am unable to workout this may be couple of days i will check and update you lech_miszkiewicz‌