topic Re: Question reReports in QlikView

Question reReports

jduenyas — Wed, 25 Nov 2020 16:16:04 GMT

All,

I have a procedure (script) that generates reports. It selects time span and individual Sales People and generates a report which I later send automatically, via a 3rd party engine, to the individual recipients.

Occasionally there is no data to report for an individual.

Is there a way to determine if there is no data in a chart so to skip the report?

Thanks

Josh

Re: Question reReports

MindaugasBacius — Wed, 06 Feb 2019 05:51:01 GMT

It depends what 3rd party engine you use.

In my experience in Macros I count the number of rows in the table that will be send:

 	SET obj = ActiveDocument.GetSheetObject("info1")
	
	control = obj.GetRowCount
	IF control> 1 THEN
	
 		send_report vTO, vCC, reportFile, vName
 		
 	END IF

Re: Question reReports

jduenyas — Wed, 06 Feb 2019 19:50:56 GMT

That worked !!!

Thanks