Evaluate value filter for Today()-1 in NP printing not work properly

[Xabinav]

Hi, 

It's seems that something wort wrong. 
I have set a filter as - Evaluate value --> Today()-1

But If QS model doesn't run one day I get report of 2 days before  

Example-  

for 11/07/2022 I want to get report of  10/07/2022, If QS model failed I get report of - 09/07/2022 
And it's mistake. 

What wrong with my definition  ? 
thanks 

[Ruggero_Piccoli]

Hi,

Qlik NPrinting doesn't evaluate filter formulas, it send them to Qlik Sense that evaluates and returns the result. So I suggest you to check on the Qlik Sense side it everything works correctly.

Another idea could be to insert that formula in the template so you can check the result in the generated report. 

Best Regards,

Ruggero 

[Jacob_Poole · Accepted solution]

Hope this will help.

For the first question, 

I have set a filter as - Evaluate value --> Today()-1  But If QS model doesn't run one day I get report of 2 days before 

Maybe try changing the expression to Today(1)-1.

This will help explain how the timer in the Today() function can impact results.

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunc...

Example-  for 11/07/2022 I want to get report of  10/07/2022, If QS model failed I get report of - 09/07/2022 
This sounds like you're looking for prior months not previous day,  you may need to use some other function possibly addmonths().

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunc...

As Ruggero suggested test it on the QS side to see if it evaluates as intended. 

[Xabinav]

what is the best way to define filter for -->  Date = Today()-1 ? 

[Jacob_Poole]

It depends on your data model, the date you're evaluating against, and the intended results. Check out the link in the response below for an overview of the Today function.  

[Lech_Miszkiewicz]

Hi @Xabinav 

both answers above are correct and tell you everything you need to know. @Jacob_Poole gave you a clue on the Today() function parameter which may be in play in this scenario and @Ruggero_Piccoli suggested how to quickly test it (by putting expression directly in Qlik Sense expression in any of the objects which allows for expressions).

I am not sure what else is not clear? Please give us a hint which part you are struggle with.

btw - the formula you are using is normally correct, so maybe just add "1" to the Today(1) function and it may be all good. 

[Xabinav]

Thanks
I will try and update.  

This sounds like you're looking for prior months not previous day,  you may need to use some other function possibly addmonths().  

I meant to yesterday. (we use date at this form -  'DD/MM/YYYY' )