Does chart have records

Mon, 07 Oct 2013 16:41:11 GMT

I have a chart the uses a set analysis to trap exceptions. I send this chart to excel and then email the excel file to a users to review the exceptions. This is all automated on reload. If the chart has no records (there are no exceptions today) I do not want to email an empty excel file. How do I determine if a chart has any records?

Thanks,

Stephen

Re: Does chart have records

Mon, 07 Oct 2013 18:01:08 GMT

Figured it out. Using:

set obj = ActiveDocument.GetSheetObject("CH01")
set v = ActiveDocument.Variables("vCountRecords")
v.SetContent obj.GetRowCount,true

if v.GetContent.string = 2 then
msgbox ("Don't Send Email")
else
msgbox ("Send Email")
end if

The 2 record count represent the caption and the totals line in the straight table, so only if there are 3 or more records is the actual data in the table.

Stephen

topic Does chart have records in QlikView

Does chart have records

Re: Does chart have records