Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Check if the filters return null

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

1 Solution

Accepted Solutions
mwoolf
Honored Contributor II

Re: Check if the filters return null

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


now val.Count is the number of possible values

1 Reply
mwoolf
Honored Contributor II

Re: Check if the filters return null

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


now val.Count is the number of possible values

Community Browser