topic Attached example - Circular Reference problem in QlikView

Attached example - Circular Reference problem

Thu, 28 May 2009 23:30:09 GMT

Hi,

Please see attached example of a Sample app that demonstrates circular reference problem. Due to circular reference, selecting ABS from Financial (Level #2), show plan as 0 instead of 1700

Can someone please help me resolve this issue? I cannot create a link table based on both Financial and Team. Both these tables has huge no. of records and cross cartisan table is not possible between these two.

I searched thro the forums for Circular reference issue but could not find satisfactory result. I hope the attached example would help to understand the issue.

Thanks in advance!

Regards

Attached example - Circular Reference problem

Fri, 29 May 2009 14:57:43 GMT

Hello,

I modified your script and load the PLAN_DATA table twice.

Maybe this put you in the direction to solve your problem.

Rainer

Attached example - Circular Reference problem

Mon, 01 Jun 2009 22:44:00 GMT

rfa - thanks for the reply..

I am not sure if the attached solution is working. I understand that you wanted to point me in a direction to use Qualify, but so far I am unable to implement to get it work.

In the solution that you posted, the CV by Teams chart should display below Plan nos when ABS is selected

461243 (UK) 800
847215 (SINGAPORE) 900

This totals upto 1700. However, in your solution, both UK and SINGAPORE shows 1700 each.

My requirement is to calculate plan nos. with any Team (level 1) and Financial (level 2) combination. Would appreciate if you can provide some guidance..

Attached example - Circular Reference problem

Tue, 02 Jun 2009 02:15:26 GMT

Please see the attached file.May be you could use the mapping to combine CV and Plan data together...not sure if there a better solution to this.

Thanks.

Attached example - Circular Reference problem

Wed, 03 Jun 2009 20:24:27 GMT

Raj,

Yes, it did work! Only issue I had was that I was creating the maps based on QVD files and it wasnt working as expected. Found somewhere in the forum that maps do not work when loading data from qvd, so added a where condition 1=1 when loading data from those particular qvd files. But otherwise, solution worked fine! Thanks a lot!!