topic Re: Getfield Selection value not available in QlikView

Getfield Selection value not available

venkatasubramanian — Sat, 16 Nov 2024 20:14:52 GMT

I have used the following code to select a particular date. The issue here is, I am using a loop and export different selections for the same date, but if there is no date (i.e., the date which i have mentioned in my code "13") for a particular selection, it automatically exports all the date's data. Is there any solution for this.

ActiveDocument.GetField("My Calendar field").Select "13"

Thanks in advance.

Re: Getfield Selection value not available

venkatasubramanian — Tue, 20 Aug 2019 11:09:59 GMT

I did not get the answer yet, please let me know if my question is not clear

Re: Getfield Selection value not available

m_woolf — Tue, 20 Aug 2019 14:04:38 GMT

It's difficult to give a precise answer when I can see only a single line of code. I'm thinking that if the date doesn't exist, then nothing gets selected.

Maybe something like:

ActiveDocument.GetField("My Calendar field").Select "13"
set val=ActiveDocument.Fields("My Calendar field").GetSelectedValues
if val.Count >0 then
<Your code to export here>
end if