topic Re: RE:conditional report in Qlik NPrinting

RE:conditional report

Chanty4u — Wed, 25 Sep 2019 18:40:54 GMT

i have one issue.

like for example i have reports scheduled every month 4th [ this reports are latest month only]

so now my concern is from database data is not uploaded this month so no reload from qlik aswell so now in nprinting reports last month

data will send to customer which is not correct.

what is the alternate for this? is there any trigger /conditional thing to be applied to avoid this?

Best

Chanty

Re: RE:conditional report

devarasu07 — Thu, 30 Nov 2017 09:38:11 GMT

Hi,

I've not tried with Nprinting 17. in nprinting 16 method are below way

1) Connection: Create connection like our db dsn

2) report Task : try to create simple excel report using your qlikview object (here u can add filters, recipient info, attachment etc)

3) reload task: here we reload our qlikview/qvf app

4)Schedule job: create task (here we define the day/week/month schedule)

note: step 4, firstly we need to add that reload app task and then report task.

so try to find & apply similar steps in Nprint 17. are u using nov17 or earlier batch. i heard that trigger concepts available from sep'17 nrpinting onwards.

have checked this article steps for nprint 17 job schedule,

https://branch-blog.qlik.com/nprinting-api-for-noobs-7c1343a99ad8?_ga=2.205392656.1408040715.1512034060-2049832189.15108…

Thanks,

Deva

Re: RE:conditional report

Chanty4u — Thu, 30 Nov 2017 09:41:44 GMT

thanks deva.

am using 17.3 sep2017 for Qliksense

let me check . but

Devarasu R wrote:

note: step 4, firstly we need to add that reload app task and then report task.

this i dont understand deva . what it is? and how it will work your steps? because if current month data is not there how it will check the condition where i have to write the condition?

Re: RE:conditional report

devarasu07 — Thu, 30 Nov 2017 09:49:47 GMT

Hi,

for the conditionally generate the report in 16, we have option in GUI @ 16 and i'm not sure about in 17

FYI, here we write all our rule (like if sales >1000 )

How to Control Report Generation with Conditions

Re: RE:conditional report

devarasu07 — Thu, 30 Nov 2017 09:55:07 GMT

hi,

This feature available in Nov'17

Conditions ‒ Qlik NPrinting

Re: RE:conditional report

Chanty4u — Thu, 30 Nov 2017 09:57:43 GMT

Hi Dev,

17 also having the option but how can i add my condition?

like if max month data is not there how to flag ? which condition i have write?

any variable to create in qlik? and how to get it?

Re: RE:conditional report

Chanty4u — Thu, 30 Nov 2017 10:00:31 GMT

got it but i am confusing how to give the condition based on my requirement

to achieve this if max month is not available the report should not send to the customer

Re: RE:conditional report

Ruggero_Piccoli — Thu, 30 Nov 2017 11:35:16 GMT

Hi,

QlikView has the function ReloadTime() that returns a timestamp for when the last data load finished. Refer to: https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/SystemFunctions/system-functions.h…

So you can create a variable, called for example IsQVReloaded that compares when last reload was done with today date. For example you can use a formula like: =(TEXT(DATE(ReloadTime(), 'YYYYMMDD')) = TEXT(DATE(Today(), 'YYYYMMDD'))). Of course you must customize the formula to met your requirements. I use this because I have a ready example that is designed to check if a .qvw is reloaded daily.

Then create a condition that is true when the variable is true. Refer to https://help.qlik.com/en-US/nprinting/November2017/Content/ReportsDevelopment/Conditions.htm

Create a task, add the condition into the task and schedule it. The report will be created only if the condition, so the reload, is met.

If you are using a connection to a local QlikView document, remember to trigger a metadata reload otherwise NPrinting will still use the old data.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: RE:conditional report

Lech_Miszkiewicz — Thu, 30 Nov 2017 11:59:03 GMT

Agree with Ruggero in 100%

Re: RE:conditional report

Chanty4u — Fri, 01 Dec 2017 06:07:39 GMT

Hi ruggero.piccoli‌ thanks alot for the suggestion and here one more clarification

here i need to create this in one variable ? =(TEXT(DATE(ReloadTime(), 'YYYYMMDD')) = TEXT(DATE(Today(), 'YYYYMMDD'))

and what is the constant here in screenshot?? hw we will declare that?

Re: RE:conditional report

Chanty4u — Fri, 01 Dec 2017 06:08:46 GMT

thanks lech_miszkiewicz‌ do you have any sample ?

Re: RE:conditional report

Daniel_Jenkins — Fri, 01 Dec 2017 06:22:46 GMT

Hi Chanty,

Create the variable in your QlikView document like this:

If the document has been reloaded today the value of IsQVReloaded will be -1

Use that variable exactly as in Ruggero's solution.

HTH - Daniel.

Re: RE:conditional report

Chanty4u — Fri, 01 Dec 2017 06:32:34 GMT

thanks @daniel but for me its giving " 0 "

Re: RE:conditional report

Chanty4u — Fri, 01 Dec 2017 06:38:33 GMT

Hi djk for me today() function giving the yesterday date thats why it is giginvg 0 i think am i correct? and why today function giving yesterday date? check the attached image for today function

Re: RE:conditional report

Chanty4u — Fri, 01 Dec 2017 06:43:34 GMT

i think do i need 0 in today function?

=today(0) ?

Re: RE:conditional report

Daniel_Jenkins — Fri, 01 Dec 2017 06:46:03 GMT

Try with Today(1)

http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/today.htm

HTH - Daniel.

Re: RE:conditional report

Chanty4u — Fri, 01 Dec 2017 06:50:06 GMT

thanks daniel shall i use -1 in the nprinting condition as constant=-1 ? and what is the purpose of this constant?

Re: RE:conditional report

Ruggero_Piccoli — Fri, 01 Dec 2017 08:22:10 GMT

Remember that you have to customize the function that defines the variable in order to met your specific requirements. To do this you have to use normal QlikView functions.

The variable I suggested comes from an example that is designed to check if a QlikView document is reloaded daily.

About -1 or 0 refer to Relational operators ‒ QlikView‌. "All relational operators compare the values of the operands and return True (-1) or False (0) as the result. All relational operators are binary."

So -1 is the value for True in QlikView. 🙂

I hope this helps.

Best Regards,

Ruggero

---------------------------------------------

Re: RE:conditional report

Chanty4u — Fri, 01 Dec 2017 08:52:36 GMT

Nice Ruggero thanks. Now am creating sample and testing. let you know if i found any issue

Re: RE:conditional report

Lech_Miszkiewicz — Fri, 01 Dec 2017 08:59:16 GMT

Always have a sample somwhere:

condition expression for reload today in Nov 2017 Release

btw:

Did you check community before asking your question ??? I know that i am beeing a smart***, but... why not?

Have a nice weekend - cheers Lech