I cant wait to get my hands on the embedded functionality. Need to get my upgrade done.
On the only message front could you add your message into the Qlik Sense App with a flag to id message 1, 2 3 etc... and then use the user filter to filter down to the mesage you want to display that way you will just have one message field in your report. My guess is they have some role that determines their communication method.
Hey Andy, thanks for the help - this made me think to try creating a Qlik Sense variable for each message, then use a separate variable to handle the conditional message selection. I then tried to drop this variable into the NPrinting report as a variable/formula (tried both). Unfortunately the problem is still that I need to include the HTML markup into the message, and NPrinting sees the markup as text rather than HTML tags. There could be something I'm missing here.
The HTML report body:
<body onload="showMessage()"> <div> <p> Your current status known compliance is %%ComplianceRate%% </p> <div id="Full"> <p>You're awesome - fully compliant!</p> </div> <div id="Meets"> <p>You're doing great!</p> </div> <div id="Below"> <p>You're getting there</p> </div> </div> </body>
The MessageType formula expression using my Qlik Sense variable:
if($(vPercentInfluenzaStatusKnown) = 1, 'Full', if($(vPercentInfluenzaStatusKnown) >= 0.8, 'Meets', 'Below'))
I'm giving up on this for now. If I figure it out I'll post in this thread.
<SCRIPT > I have been there, I have done that..
I tried also use script in my html to build google charts and hit the same roadblock and I gave up realisisng that mail client will not support it - SHAME
Back to your question:
If you want to go this path you will have to handle all in Qlik Sense / QlikView side. So depending on variable you need to produce outcome.
Things you need to consider are:
- condition needs to be evaluated within the same object as you will only reference always the same object in NPrinting. Therefore you will end up with nested if statements or set analysis. If yo uhave created 3 messages in 3 different objects yo uneed to put all of them into one object and use condition in Qlik to decide which part of message is getting sent
Let vVar1 = 'Today is Monday the first day';
Let vVar2 = 'Today is Tuesday the second day';
Let vVar3 = 'Today is Wednesday the third day';
above you have 3 variables. What you currently are doing is looking at them as a separate objects and want to apply condiotion which of them you want to show in NPrinting- right?
My idea is that you only need to have one variable like:
Let vSingleVariable = If(condition1 = true(), vVar1,If(condition2 = true(), vVar2,If(condition3 = true(), vVar3.... etc...)))
then in NPrinting you only use vSingleVariable to show your message, and its content gets calculated in Qlik.
Obviously i have presented example with variables, maybe you have charts, textboxes or whatever - still, the principle is the same.
Can you share a mockup what is your variable, how is it calculated? Is it recipient based? and what is your report scenarios likely looking like (template).I am sure we will find a solution for your request as it seems to be achievable.