Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

PDF Distribution

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.

Tags (1)
1 Solution

Accepted Solutions
srchilukoori
Valued Contributor

Re: PDF Distribution

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.

9 Replies
srchilukoori
Valued Contributor

Re: PDF Distribution

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?

Not applicable

Re: PDF Distribution

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
Valued Contributor

Re: PDF Distribution

Did you try using the date selection on post reload?

Not applicable

Re: PDF Distribution

Yes I did

Not applicable

Re: PDF Distribution

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

srchilukoori
Valued Contributor

Re: PDF Distribution

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

Not applicable

Re: PDF Distribution

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
Valued Contributor

Re: PDF Distribution

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.

Not applicable

Re: PDF Distribution

Thank you It worked