topic Re: Nprinting Condition Task in Qlik NPrinting

Nprinting Condition Task

ch_riadh — Sun, 20 Oct 2019 10:19:13 GMT

Hi,

I have a table with 4 Fields:

1- Brand

2- Product

3- Date

4- Stock

i want to create Condition task in nprinting 18 Nov, when the stock of any product from any branch on any date = 0,

Send me a report details (Brand, Product and Date).

Thank you

Re: Nprinting Condition Task

Lech_Miszkiewicz — Mon, 21 Oct 2019 04:05:01 GMT

read documentation first to understand how conditions work.

https://help.qlik.com/en-US/nprinting/June2019/Content/NPrinting/ReportsDevelopment/Conditions.htm

then depending on your datasource (QlikView or Qlik Sense) you can use chart table in qlik to create condition object.

If you have something else in mind please provide detailed information regarding setup, report and what you want to report in form of mockup so we have something to work with.

From your question it is not clear whether you actually need a condition or filter

Re: Nprinting Condition Task

ch_riadh — Mon, 21 Oct 2019 06:50:23 GMT

I'm using qliksense with nprinting 18

for example after reload data today morning

The stock for brand A of product X on 21/10/2019 become 0.
so i need to receive an email with the brand, product and date for that 0.

Re: Nprinting Condition Task

Lech_Miszkiewicz — Mon, 21 Oct 2019 08:17:27 GMT

Ok then, build the table in Qlik Sense to show only 0 values and use it as a condition (chart has values) to run report and as a source to show which brand, product and date it is for. Obviously this will very much depend on how you pull data. Does your 0 stock actually contain value 0 or it has no associated value (hence you assume it is 0)

If you want real examle share some sample qvf app so i can build on top of it.

cheers

Lech

Re: Nprinting Condition Task

ch_riadh — Mon, 21 Oct 2019 08:51:31 GMT

please find the excel file. nprinting should send a report with this info: Nike short 21/10/2019

Re: Nprinting Condition Task

ch_riadh — Mon, 21 Oct 2019 08:52:54 GMT

when no stock available it shows 0.

Re: Nprinting Condition Task

Ruggero_Piccoli — Mon, 21 Oct 2019 10:52:43 GMT

Hi,

Note also that Qlik NPrinting publish tasks can be triggered only on a time bases or via APIs. There are not events driven executions.

So, after creating the condition, you need to schedule the publish task at an adequate interval of time. It will be run on time bases and, if the condition will be met, the reports will be created.

Best Regards,

Ruggero

Re: Nprinting Condition Task

Lech_Miszkiewicz — Tue, 22 Oct 2019 02:42:39 GMT

So,

As i said before - how you built your report depends mainly on your data model. Given the data you have provided you can simply built an object in Qlik Sense which will be your condition chart as well as your report source. Note that i specifically asked how you know that there is 0 stock and if this is a record with 0 value or zero as result of calculation which returns 0 due to lack of associated values).

See sample qvf based on your data source. You need to use this object as condition (Chart has values) and use it to build your report template.

Then schedule your NPrinting distribution task to be triggered right after your qlik sense finishes reload. You can use API to do this or set regular time based trigger. About API and task chaining you can read here: https://nprintingadventures.wordpress.com/2019/04/08/nprinting-api-qlik-rest-subroutines/

In this task setup condition "Chart has values" and use this chart as condition true/false indicator.

If you have different data model then you need to attach your qvf file with actual data model. You can scramble data if you need.

cheers

Re: Nprinting Condition Task

ch_riadh — Tue, 22 Oct 2019 08:45:25 GMT

I use the same qvf you sent to me, and create a condition chat has value then send me mail.
it works fine when there is a stock with 0.

but when i try to add stock to my data. (all products have a stock), and run the task. i still recieve the report with

Re: Nprinting Condition Task

Lech_Miszkiewicz — Tue, 22 Oct 2019 09:41:25 GMT

You need to build your expression in qlik sense stock to only show 0 values which i did by using set analysis in my example. Without your data model i will not be able to help

Re: Nprinting Condition Task

ch_riadh — Tue, 22 Oct 2019 10:28:08 GMT

even with the sample excel i sent we still recieve the email cos qlik consider a table with '-' like the pic i send : a table with value

Re: Nprinting Condition Task

ch_riadh — Tue, 22 Oct 2019 12:06:32 GMT

what you did is good, but qlik consider table with '-' as a table with data.

so i still recieve the email in both cases.

Re: Nprinting Condition Task

Lech_Miszkiewicz — Tue, 22 Oct 2019 12:08:46 GMT

Uncheck include “null” on dimension settings

Btw...this becomes really Qlik Sense question how to configure chart...

Re: Nprinting Condition Task

ch_riadh — Tue, 22 Oct 2019 13:10:54 GMT

no bro,

try it with that simple data i sent to you , then take pic and show me that the table is without values.

( Show null value !!!! )

Re: Nprinting Condition Task

Lech_Miszkiewicz — Tue, 22 Oct 2019 21:05:14 GMT

Hi,

we are not "bros" and please, let's keep it this way.

I see your point regarding the fact that table is still visible (has 0 value) and no dimension values. But again this is just Qlik Sense development situation and nothing special.

You just need to suppress 0 values and add a column which will indicate that there is a stock = 0; for example count of 0 stock which in attached app i called "Has Values" (since 0 stock would also be suppressed if you just have 1 measure)

chart without values and with "include zero values" unchecked

chart with values and with "include zero values" unchecked hence need for "Has Values" column

See sample attached.

Re: Nprinting Condition Task

ch_riadh — Wed, 23 Oct 2019 09:22:00 GMT

Hi.

Maybe i gave you a very sample excel.

please find the attached file. and with that excel just show the empty table like you sent me before.

thank you in advance

Re: Nprinting Condition Task

Lech_Miszkiewicz — Wed, 23 Oct 2019 11:47:34 GMT

Hi,

I don't know what you did not understand from my suggestions. I clearly said that I need your data model if you want to specific instructions how to do it. I also said that this is not NPrintign related question anymore, as you are simply struggling with building right expression for your chart.

Building chart is dependent on datamodel and the way you load data. So put together qvf or qvw file - it can be with dummy data, attach it here and then I may try to help you.

You now gave me another excel which does not meet criteria of your initial question. So how do you expect me to help you?

Re: Nprinting Condition Task

ch_riadh — Wed, 23 Oct 2019 12:42:29 GMT

forget nprinting,

i have only that excel file and i want a simple table with ( stock location, date and stock ) to be displayed empty, cos sum of stock every day per stock location not zero

Re: Nprinting Condition Task

Ruggero_Piccoli — Wed, 23 Oct 2019 14:36:21 GMT

Hi,

If it is a Qlik Sense usage case I suggest you to post it in Qlik Sense community, it will be easier to find an expert that could help you. You could also search there if there are similar questions with related solutions.

Best Regards,

Ruggero

Re: Nprinting Condition Task

Lech_Miszkiewicz — Thu, 24 Oct 2019 01:10:21 GMT

I have already given you qvf in my previous post with ready solution (chart and expressions i used to show 0 values rows).

I am not sure which part you did not understand? Are you Qlik developer? Do you know set analysis?

If not, then maybe you should get a consultant to help you on site as this maybe little bit too much for someone who is not experienced with set analysis syntax. On the other hand if you do know set analysis then:

create straight table in Qlik Sense
put your stock location dimension (Include null values unchecked)
put your date as dimension (Include null values unchecked)
put your expression Sum({<Stock={0}>}Stock) - this will show only 0 values for stock location and date combinations
go to add-ons--> data handling --> uncheck "Include zero values"
put another expression Count({<Stock={0}>} [Stock location]) - if there is a line with stock = 0 it will produce value > 0 hence this line will be visible, but it will only produce it for line where stock is 0
this object can be used for your condition to send report as well as for data source in your template

I see you are the qlik partner-if you have any doubths about the above logic maybe check with the coleagues? I think i have explained everything well here, you have working example (attached with the data you sent) and i have no idea what else i can do?

Last thing - To get a right answer firs you need to ask right question and spent time preparing it. In the course of this conversation i asked many times for qvf file with sample data and never received one and as a Qlik partner you should know well that the same excel data can be loaded in many different ways and you can use data from it in many different ways in Qlik UI. From the above conversation it is not clear if you want to show 0 values for particular data row or If you want to show 0 values when 0 is a result of aggreagtion of multiple rows. I asked about it before and never got an answer. I think I spent enough time to explain this properly, I pointed you to the right solution, given you few examples. If this is not enough I think you should get experienced Qlik consultant to helpp you with this.