Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Qvd Data not coming

Dear Member,

I have one year data and I am fetching a field(AVM_NR) from one qvd and count of that one is 1000. When i am reloading the same qvd my count is 500 for that fileld called "AVM_NR". I am using 8.2 version. I think because of macro i am getting wrong data.

My Macro is

sub calcmin

set min = ActiveDocument.Variables("currentdatemin")

set max = ActiveDocument.Variables("currentdateMax")

set f=ActiveDocument.Fields("E_Date_New")

f.clear

f.Select ">=" + min.GetContent.String + "<=" + max.GetContent.String

end sub

In E_Date_New suppose if i select May 2012 count of AVM_NR is 757915

If i select the same in the original file for MAy 2012 count of AVM_NR is 258887.

Can you please tell me y am in not getting the data.

Regards,

RBK

0 Replies