Label name Dynamic

[Chanty4u]

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?

[arvind_patil]

Hi Chanty,

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

Thanks,

Arvind Patil

[Chanty4u]

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]

[Lech_Miszkiewicz]

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

[Chanty4u]

yes lech exactly.

in qliksense its working but not in Np 

how to overcome this?

[Chanty4u]

Hi Lech Miszkiewicz

any update on this?

[Lech_Miszkiewicz]

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

[Chanty4u]

Okay Lech,

thanks

[Lech_Miszkiewicz · Accepted solution]

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

[Chanty4u]

thanks lech,

am not using levels 

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