Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted

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

Highlighted
Creator
Creator

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

HOW can i do

Highlighted

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

Highlighted
Creator
Creator

thank i will try,

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

Highlighted

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