<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Qvd Data not coming in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Qvd-Data-not-coming/m-p/422163#M157303</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;Dear Member,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;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.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;My Macro is&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;sub calcmin&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;set min = ActiveDocument.Variables("currentdatemin")&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;set max = ActiveDocument.Variables("currentdateMax")&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;set f=ActiveDocument.Fields("E_Date_New")&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;f.clear&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;f.Select "&amp;gt;=" + min.GetContent.String + "&amp;lt;=" + max.GetContent.String&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;end sub&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;In E_Date_New suppose if i select May 2012 count of AVM_NR is 757915&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;If i select the same in the original file for MAy 2012 count of AVM_NR is 258887.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;Can you please tell me y am in not getting the data.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;Regards,&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;RBK&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 30 May 2013 07:32:25 GMT</pubDate>
    <dc:creator>bharatkishore</dc:creator>
    <dc:date>2013-05-30T07:32:25Z</dc:date>
    <item>
      <title>Qvd Data not coming</title>
      <link>https://community.qlik.com/t5/QlikView/Qvd-Data-not-coming/m-p/422163#M157303</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;Dear Member,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;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.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;My Macro is&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;sub calcmin&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;set min = ActiveDocument.Variables("currentdatemin")&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;set max = ActiveDocument.Variables("currentdateMax")&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;set f=ActiveDocument.Fields("E_Date_New")&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;f.clear&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;f.Select "&amp;gt;=" + min.GetContent.String + "&amp;lt;=" + max.GetContent.String&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;end sub&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;In E_Date_New suppose if i select May 2012 count of AVM_NR is 757915&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;If i select the same in the original file for MAy 2012 count of AVM_NR is 258887.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;Can you please tell me y am in not getting the data.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;Regards,&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;RBK&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 30 May 2013 07:32:25 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Qvd-Data-not-coming/m-p/422163#M157303</guid>
      <dc:creator>bharatkishore</dc:creator>
      <dc:date>2013-05-30T07:32:25Z</dc:date>
    </item>
  </channel>
</rss>

