Check if the filters return null

[#1]

Hi All,

I am working on exporting few things from qlikview to PPT.

In order to achieve that I am using Macros.

One of things I am doing is filtering using following instruction:

Activedocument.fields("Country").select "United Kingdom"

It might be though that none of rows in the table I am filtering is meeting that criteria - is there any way of checking if the above instruction returns no rows?

Would appreciate any help

[m_woolf · Accepted solution]

set val=ActiveDocument.Fields("Country").GetPossibleValues

now val.Count is the number of possible values