Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have one issue.
like for example i have reports scheduled every month 4th [ this reports are latest month only]
so now my concern is from database data is not uploaded this month so no reload from qlik aswell so now in nprinting reports last month
data will send to customer which is not correct.
what is the alternate for this? is there any trigger /conditional thing to be applied to avoid this?
Best
Chanty
thanks lech_miszkiewicz do you have any sample ?
Hi Chanty,
Create the variable in your QlikView document like this:
If the document has been reloaded today the value of IsQVReloaded will be -1
Use that variable exactly as in Ruggero's solution.
HTH - Daniel.
thanks @daniel but for me its giving " 0 "
Hi djk for me today() function giving the yesterday date thats why it is giginvg 0 i think am i correct? and why today function giving yesterday date? check the attached image for today function
i think do i need 0 in today function?
=today(0) ?
Try with Today(1)
HTH - Daniel.
thanks daniel shall i use -1 in the nprinting condition as constant=-1 ? and what is the purpose of this constant?
Remember that you have to customize the function that defines the variable in order to met your specific requirements. To do this you have to use normal QlikView functions.
The variable I suggested comes from an example that is designed to check if a QlikView document is reloaded daily.
About -1 or 0 refer to Relational operators ‒ QlikView. "All relational operators compare the values of the operands and return True (-1) or False (0) as the result. All relational operators are binary."
So -1 is the value for True in QlikView. 🙂
I hope this helps.
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
Nice Ruggero thanks. Now am creating sample and testing. let you know if i found any issue
Always have a sample somwhere:
condition expression for reload today in Nov 2017 Release
btw:
Did you check community before asking your question ??? I know that i am beeing a smart***, but... why not?
Have a nice weekend - cheers Lech