topic Load data from view in Qlik in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Load-data-from-view-in-Qlik/m-p/1416361#M3106 <HTML><HEAD></HEAD><BODY><P>hi all</P><P>I am loading data in Qlik sense from a view created on oracle DB, all data loaded correctly </P><P>except a char field which returns from a decode function depending on dates comparison in the view.</P><P>All data in the view on DB are correct.</P><P>when loaded to Qlik only this field loads 1 value only despite it actually holds more than 1 value in DB.</P><P>Does Qlik execute the view again when loading?</P></BODY></HTML> Thu, 17 Aug 2017 08:42:55 GMT monaali602 2017-08-17T08:42:55Z Load data from view in Qlik https://community.qlik.com/t5/Connectivity-Data-Prep/Load-data-from-view-in-Qlik/m-p/1416361#M3106 <HTML><HEAD></HEAD><BODY><P>hi all</P><P>I am loading data in Qlik sense from a view created on oracle DB, all data loaded correctly </P><P>except a char field which returns from a decode function depending on dates comparison in the view.</P><P>All data in the view on DB are correct.</P><P>when loaded to Qlik only this field loads 1 value only despite it actually holds more than 1 value in DB.</P><P>Does Qlik execute the view again when loading?</P></BODY></HTML> Thu, 17 Aug 2017 08:42:55 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Load-data-from-view-in-Qlik/m-p/1416361#M3106 monaali602 2017-08-17T08:42:55Z