topic Re: Date Field in Nprinting in Qlik NPrinting

Date Field in Nprinting

ElifGuler — Mon, 03 Oct 2022 07:17:09 GMT

Hello,

I've tried to use nprinting for the first time. I created filters and users by import task, but could not create date field filter.

I've tried text format or date format but it seperates the expression like two different fields as below. What should I do?

Field : DATE(ARVENTO_DATE,'DD.MM.YYYY') AS DATE_ARVENTO_DATE

Import Task Excel:

Nprinting:

Re: Date Field in Nprinting

Lech_Miszkiewicz — Mon, 03 Oct 2022 11:54:13 GMT

Hi @ElifGuler

which topics of already many discussed on community have you reviewed before posting your question about date field filter?

I have explained in many of them importance of understanding data type of date field and therefore consequence of options used in filters

i have also written blog posts about this (check all with filters subject here https://nprintingadventures.com/category/nprinting/filters/

cheers

Re: Date Field in Nprinting

ElifGuler — Mon, 03 Oct 2022 14:14:36 GMT

Hello @Lech_Miszkiewicz ,

I guess the problem is not format of the field , since I can write the expression nprinting filters area and it works but I want to import via excel, but it does not understand the expression is for one field because of comma between date() and 'dd.mm.yyyy' probably. It shows the filter like below

Re: Date Field in Nprinting

Ruggero_Piccoli — Mon, 03 Oct 2022 15:15:10 GMT

Hi,

In the screenshot the formula is split in two rows. I suggest testing the formula in Qlik Sense and only when it works there copy and paste it in Qlik NPrinting.

Qlik NPrinring sends the formulas to Qlik Sense who evaluates them and returns the results. So formulas must work in Qlik Sense (or QlikView).

Best Regards,

Ruggero

Re: Date Field in Nprinting

ElifGuler — Mon, 03 Oct 2022 15:22:26 GMT

Hello,

I had already tried in qliksense. Format was right. I solve the problem with double-quote in excel which is used in import task like;

date_arvento_date = { “date(today()-1, ‘DD.MM.YYYY’)”}

now it writes whole expression for one field and it works.

thank you for your replies

Re: Date Field in Nprinting

Lech_Miszkiewicz — Tue, 04 Oct 2022 09:59:00 GMT

@ElifGuler I see - well the question then was about problems regarding import syntax and single quotes. I am glad you got this working finally.

Now my comments still applies to this as in your case you didn't have to use Date() functional at all and therefore you wouldnt have to worry about single quotes mark in excel import file. If your date field is of the type Date, numeric, integer... then you could simply use =floor(Today()-1) and it should still work ok as filter in evaluate value still expects numerical value of the as a filter.

Re: Date Field in Nprinting

David_Friend — Tue, 04 Oct 2022 14:48:42 GMT

@ElifGuler be sure to mark that solution from @Ruggero_Piccoli as the Solution for this, thanks!

Re: Date Field in Nprinting

Lech_Miszkiewicz — Wed, 05 Oct 2022 00:04:43 GMT

Hi @David_Friend - i reckon @ElifGuler 's own answer is correct to this topic and will help others with the same problem - hence I think that one should be marked as solution.

Ruggero and mine suggestions were correct in some areas but wouldn't solve the issue entirely.

That is my opinion on that.