Data Modelling Help

[satishsure]

I need to implement the data model for the below sql query .Please help me in this.

Select *

from account a

left join account bq

       on bq.id = [bo].[GetAccountId](a.id,0)  //scalar function

left join account  bqSameBiz

       on bqSameBiz.id = [bo].[GetAccountId](a.id,1)

left join markets  market

  on a.id = market.id

Where a.RepUser = 1 or a.Rep = 1

[#2]

Hello Satish,

If you want import data from this query in QlikView, then You can use the preceding load, as below:

MyTable:

Load *;

Select *

from account a

left join account bq

       on bq.id = [bo].[GetAccountId](a.id,0)  //scalar function

left join account  bqSameBiz

       on bqSameBiz.id = [bo].[GetAccountId](a.id,1)

left join markets  market

  on a.id = market.id

Where a.RepUser = 1 or a.Rep = 1

Otherwise, I don't understand the question.

Regards,

-Antonio.

[tajmohamed30]

my suggestion that you can save the source from DB and save it to QVD and then load into qlikview and try working in data modelling

[satishsure]

Thanks ..Taj..Actually our process will import only tables to qvds then I need to implement this query from qlikview end.I will get only tables... 😞

[satishsure]

I will get the tables as qvds and need to implement the query.

I have 2 qvds ( account.qvd and markets.qvd)  with all columns. With these qvds i need to implement the above sql query in qlikview. I can not connect Data base from qlik end. I will get only qvds.