topic Chart Set Analysis not working when emailing in QlikView

Chart Set Analysis not working when emailing

Wed, 14 Apr 2010 23:00:53 GMT

I have code behind a button that does the follow:

1) Selected the current Year

2) Select the current Month

3) Selects the email recipient

4) Export a chart to excel

5) Emails the excel file the user.

All works, however, the YTD set analysis portion of the chart does not reflect YTD data in the email (or on the chart).

However, if I select everything manually (ie not through the button) the YTD set analysis portion of the chart is calculates acurately.

Any ideas what is happening?

Stephen

Chart Set Analysis not working when emailing

mike_garcia — Thu, 15 Apr 2010 02:02:34 GMT

Hi,

What is the formula you are using for the set analysis portion? What Actions (or Macro?) does the button have?

Is it possible for you to post an example qvw?

Mike.

Chart Set Analysis not working when emailing

Oleg_Troyansky — Thu, 15 Apr 2010 03:21:48 GMT

I can only guess that the commands are being processed so fast that the chart is being exported before it's recalculated. If this is a macro, there is an API that takes care of it:

WaitForIdle - look it up in the API guide.

If you are doing it using Actions, - then I'm not sure you can force a pause to let all the charts recalculation prior to sending the e-mail. Just to verify the theory, try splitting the job into two buttons - first button applies selection, and the second button does the export and the e-mail part.

cheers,

Chart Set Analysis not working when emailing

Thu, 15 Apr 2010 16:33:39 GMT

Found my problem. There are two fields that represent the month, one is a number the other is the name of the month. My set analysis was looking the the number, when I changed it to look at the name it worked.

It didn't look like I needed the WaitForIdle API but I did add it after the "selection"part of the code as it does process fast.

Thanks,
Stephen