Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Pomna
Creator III
Creator III

Filter By Previous Day

I need help creating a filter in Nprinting to get only values for the previous day. Below is what I have got but it does not give me the expected answer. Your suggestions will be appreciated. Thanks

Pomna_0-1600828536386.png

 

Labels (2)
12 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

In filter pane it looks like your date is not a straight field but expression. Can you try to use a naked field you mentioned you have created instead?

I just want to confirm the obvious:

  • there is no "Always one selected values"?
  • there is no "trigger"s or "default bookmarks" in this app?

1.png

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

also - do you intersect other filters which exclude themselves? User filters maybe created in this connection?

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Pomna
Creator III
Creator III
Author

Thank you so much for all the help. I realized that the report throws an error when  no report is generated or when there is no data to show. So the solutions above work. Thank you