I need help in Distributing the Report (PDF) on a Daily basis via email in Qlikview. I have attached the following for better understanding
1. SpreadSheet Data Source1 (Completes)
2. Spreasheet Data Source2 (DaysOut)
3. QVW File
This Report calculates MTD Values ( for completes) and pulls directly the Real Time Values ( for Days Out). Upon selection of filter Date in the Report MTD Values (Completes) Changes.
Now I want to generate PDF Distribution of Report By Auto selecting the Date to yesterday (today()-1)
I usually do the PDF Distribution by filtering the data at the source level (at qvd) and just pull the information for latest date = today()-1.
Here I can't do that as I have MTD Values to calculate
Can ANYONE Help me in figuring out how can generate PDF Daily for this report
1. Created Bookmark It didn't work
2. Tried filtering it the date in QVD to Today()-1 value It didn't work as I have to calculate the MTD value and just cannot filter to today()-1
I have ran out of options ... Could you please help me in generating PDF.
Solved! Go to Solution.
Day's Out Table directly pulls in the value, it is not dependent on the Date Filter selection, Completes is dependent on the filter selection. You will see the values changing in Completes Chart On selecting dates in the Calender Object.
This File was developed on 16th April, so that is the latest date for which you can see the data changing in completes Chart. I have see you made the change in the triggers. I tried using your file, there is still no luck. I don't get the PDF Report right. I can see the right numbers on the Access Point but not on PDF.
I want to automatically generate the PDF Report with the latest date, setting the triggers is not helping in generating the Report.