7 Replies Latest reply: Oct 30, 2015 7:05 AM by Pablo Labbe RSS

    Bug Where Exists (2.0.2)

    Karl Fredberg

      I get 0 rows if I load a master calender with a script and then try to load a qvd with Where Exists(date_key). It works in Qlik Sense Desktop but not on Qlik Sense Server. No rows are loaded.

       

      If I add an inline table with some random dates between the master calender and qvd load it works. Why is that?

       

      This is what the code looks like

       

      Call Calendar(params);

       

      test_dates:

      LOAD * INLINE [

          date_key,

          '2013-08-01',

          '2015-08-01',

          '2015-08-02',

          '2016-01-01'

      ]

      WHERE Exists(date_key)

      ;

       

      Fact:

      LOAD *

      FROM [lib]

      (qvd)

      WHERE Exists(date_key);