1 Reply Latest reply: Nov 29, 2015 9:20 AM by Sinan Ozdemir RSS

    How to select data from created data model in qlik sense.

      I created a different model for but same table. Example I load some data from my table property and I name it Property. I load some data again from my table property with specific selected data and named it Property 2.

       

      Property

      data1

      data2

       

       

      Property2

      data1

      data2

       

       

      I load data in property using this SQL QUery;

      [Property]:

      Load data1,

      data2;

      SQL SELECT data1,

      data2

      FROM PROP.PUB.Property;

       

      I load data in property2 using different SQL query;

      [Property2]:

      Load data1,

      data2;

      SQL SELECT data1,

      data2

      FROM PROP.PUB.Property

      WHERE data2 <=2015;



      Is it possible to select or load data from property2? For example

      [Property3]:

      Load data1,

      data2;

      SQL SELECT data1,

      data2

      FROM Property2;



      Property2 is only created in qlik sense not literally table in my database. Any solution? Thanks for help!