Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

sakamsureshbabu
Contributor

circular ref

FYI

BILL MASTER       CALENDER       SALEBUDGET      BRANCHMASTER 
bill date                  bill date             branch                    branch
branch code            month               month                     branch code

how can i eliminate circular ref....

5 Replies

Re: circular ref

Hi,

Try to do load script some thing this ways

BRANCHMASTER

branch

branch code

Left Join

SALEBUDGET 

branch

month


BILL MASTER

bill date

branch code


CALENDER

bill date

month


Regards

Anand

sakamsureshbabu
Contributor

Re: circular ref

i am doing left join 1 syn key was came and graphs are showing 'NO DATA TO DISPLAY'

HOW can i do

Re: circular ref

Oh my bad please try this way

Main:

LOAD * Inline

[

branch, branch code

];

Left Join

SALEBUDGET:

LOAD branch, month as SalMonth;

LOAD * Inline [

branch, month

];

BILLMASTER:

LOAD * Inline [

bill date,branch code ];

CALENDER:

LOAD * Inline [

bill date,month ];

And check the combinations of fields from different tables.

Regards

Anand

sakamsureshbabu
Contributor

Re: circular ref

thank i will try,

please tell me why graphs are showing  'NO DATA TO DISPLAY'

Re: circular ref

Hi,

In above example there is no data in the tables it has only fields if you use in the original table with data then it will show no data to display.

Regards

Anand

Community Browser