Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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!


1 Reply
sinanozdemir
Valued Contributor III

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

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.

Community Browser