Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
set val=ActiveDocument.Fields("Country").GetPossibleValues
now val.Count is the number of possible values
set val=ActiveDocument.Fields("Country").GetPossibleValues
now val.Count is the number of possible values