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

Sun, 29 Nov 2015 05:14:06 GMT

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!

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

sinanozdemir — Sun, 29 Nov 2015 14:20:24 GMT

Yes, you can use Resident in your load script:

[Property3]:

LOAD

data1,

data2

Resident [Property2];

Just be aware of the natural concatenation when the field names are the same.

Hope this helps.

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

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

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