PDF Distribution

[#1]

Hi,

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.

[srchilukoori]

Are you trying to apply the date filter just to Day's out table while showing all data for the MTD in the completes chart?

[#3]

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.

[srchilukoori]

Did you try using the date selection on post reload?

[#5]

Yes I did

[#6]

If you check my document properties, I already have the triggers set. The Report is not picking up the reload selection

[srchilukoori]

There is a reason for that, today is 4/23 and there is no 4/22 in your data. Try the attached application.

[#8]

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.

[srchilukoori · Accepted solution]

Qlikview Publisher disables all the on post reload triggers. You need to set a variable in the script and use that on the chart as in the attached app.

[#10]

Thank you It worked