topic Re: Data Modelling Help in QlikView

Data Modelling Help

satishsure — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Data Modelling Help

Thu, 15 Jun 2017 14:48:31 GMT

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.

Re: Data Modelling Help

tajmohamed30 — Thu, 15 Jun 2017 14:49:42 GMT

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

Re: Data Modelling Help

satishsure — Thu, 15 Jun 2017 15:23:11 GMT

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... 😞

Re: Data Modelling Help

satishsure — Thu, 15 Jun 2017 16:19:40 GMT

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.