Adding the current cycle field value to the email subject

[dana]

Hi,

I created a report cycle based on a field value (Inspector name).

Each inspector would receive a mail.

Is it possible to add each cycle value to the email subject and body?

Thanks in  advance! 

[Lucas_Gatling]

@dana  you could try doing dynamic text in the e-mail body and use 'Inspector name' as that dynamic text tag. See the following link:

https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/DistributionSchedulesAutomation/Dist...

[dana]

Hi @Lucas_Gatling ,

 Thanks, but unfortunately, it doesn't work..

It displays the tag but not the value..

[Frank_S]

Perhaps you can try using the user tag option 'current selections' in the 'Users' email body only (click on it to open the tag options). Tags cannot be applied to the 'Subject' line).

Kind regards...

[Lech_Miszkiewicz · Accepted solution]

Hi @dana 

@Lucas_Gatling @Frank_S - lets not get confused. 

Report is cycle based - and output of such report is zip file which may contain more than 1 value of cycle values and it is not possible to pass value of cycle to email body. There is no way - full stop.

EDIT: after further discussions - you can pass scope of all values which report will be cycling through by using variable - but that is not the same as linking directly cycle value with some entity in email content. So basically all you do is pass selection state for report rather than anything else.

Now, the only way of passing anything from Qlik app to NPrinting report is either by:

• native built-in NPrinting user tags which you guys mentioned (but they are not linked directly to cycle fields)
• or by Qlik variable, but that in return will need to be :
  • expanded in Qlik
  • there will have to be user filter applied and that user filter will have a direct impact what that value of variable is.

Bottom line is - that cycles are in no direct way  linked to distribution list  and lets make it very clear that only user filters can have any impact. I see confusion in that regard and people are asking over-and over again the same question (for example another one from today: https://community.qlik.com/t5/Qlik-NPrinting/Create-dynamic-filter-for-each-user-by-its-username/td-...)

[dana]

Hi @Lech_Miszkiewicz ,

Thanks for clarifying.

I hope the  option to insert the cycle value  in a friendly manner to the email  subject and body  would be added to NP.

[Lech_Miszkiewicz]

Hi @dana 

it will not as it does not make sense. Cycle feature is only loop and create report for each value of dimension, but sending aspect is not in that process.

That would be fundamental change to whole concept of cycle and I will say to keep your hopes very very low on any further development in this area. sorry

[dana]

Hi @Lech_Miszkiewicz ,

Why doesn't it make sense to have the current dimension value (in the cycle) displayed in a mail?

[Lech_Miszkiewicz]

Well - it doesnt make sense because you can have more than one dimension value in cycle report going in single email to end user. You can have 2,3 even 10  or more different nested cycle dimensions which are going to be part of single attachment.  Assume you have Dimension 1, with values A,B,C; and Dimension 2 with values x,y,z. 

If you create cycle using those fields your output will be 9 files Ax,Ay,Az,Bx,By,Bz and Cx,Cy,Cz all zipped into ZIP file. So what is your goal? Is it to say that your report contains: Ax,Ay,Az,Bx,By,Bz and Cx,Cy,Cz in email body or subject? If that is the case you can do that by creating variable directly in Qlik Sense or QlikView using =Concat(Distinct Dimension1&'-'&Dimension2,'|') and then use that in your email body. Make sure your variable expands as documented: https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/Troubleshooting/Variables-dont-expan...

That will be equivalent of all combinations and you dont need any extra functionality to put that into email subject. The scope of what will go to that variable will depend on all filters which your report applies including user filters. 

If your

[dana]

Hi,

I agree that it doesn't make sense in the scenario you described.

One thing I still not fully understand is the use of variable in context of a cycle based on a dimension.

Is it possible to link the current cycle value to the relevant dimension value by a variable?

Thanks!