@David_Friend, many thanks for your reply. so, in qlik sense, my charts contain 3 months of data but the nprinting report which we want to publish should have only the latest 9 days of data.
For example, in qlik sense dashboard, one of my line charts has 3 months of data but when the same line chart goes in a nprinting report it should have only 9 days of data.
First, check that your formula works in your qlik sense app. You can do this by adding a text box to your Qlik sense app and applying the formula inside the expression editor of your text box.
If you get a result then you can use it as an NPrinting Advanced filter.
See the following for details.
(note you must use advance filters as your formula is extracting a 'range' of values. this won't work anything but the Advanced Filter option).
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.
