topic Re: circular ref in Qlik Learning Discussions

circular ref

sakamsureshbabu — Fri, 12 Dec 2014 10:29:31 GMT

FYI

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

how can i eliminate circular ref....

Re: circular ref

its_anandrjs — Fri, 12 Dec 2014 10:54:26 GMT

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

Re: circular ref

sakamsureshbabu — Fri, 12 Dec 2014 11:51:23 GMT

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

its_anandrjs — Fri, 12 Dec 2014 11:58:43 GMT

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

Re: circular ref

sakamsureshbabu — Fri, 12 Dec 2014 12:11:36 GMT

thank i will try,

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

Re: circular ref

its_anandrjs — Fri, 12 Dec 2014 18:35:14 GMT

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