topic Re: Omission of loop created & to achieve what is expected in QlikView

Omission of loop created & to achieve what is expected

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

Dear Our Experts

Please help me to overcome the issue I am forwarding to you. I have loaded two tables both table carries BR_CODE , PRODUCT_CODE hence when the data are loaded a loop is created. What I did was to rename the BR_CODE as B_CODE then the former issue wont come but what I expect is not getting. As can be seen what is in the NRP Table total sum of both RA & EH get populated in every Branch code. Actually what is in the NRP table carries data for only RA & EH codes. Please go through my working & help me to get my output.

Thanks

Neville

Re: Omission of loop created & to achieve what is expected

nevilledhamsiri — Mon, 08 Oct 2018 15:48:12 GMT

Please let me have the answer on the body of the reply as I work on personnel edition.

Thanks

Re: Omission of loop created & to achieve what is expected

nevilledhamsiri — Mon, 08 Oct 2018 16:05:21 GMT

Appreciate if this is looked in to.

Thanks in advance

Re: Omission of loop created & to achieve what is expected

nevilledhamsiri — Mon, 08 Oct 2018 17:07:22 GMT

Dear Friends

Kindly look in to this if you are free

Neville

Re: Omission of loop created & to achieve what is expected

juraj_misina — Tue, 09 Oct 2018 06:28:40 GMT

I think that you should try concatenating both tables. Thus you would not need to rename BR_CODE and won't get any loops.

Re: Omission of loop created & to achieve what is expected

nevilledhamsiri — Tue, 09 Oct 2018 16:32:15 GMT

Hi, Juraj

There are three tables rather one comes through inline loading. The issue is even if it is concatenated, my required out put wont come. Could you please send me your answer in the body of the reply

Thank you

Neville

Re: Omission of loop created & to achieve what is expected

nevilledhamsiri — Tue, 09 Oct 2018 16:49:27 GMT

Dear Stefan, Viswarath,Dilip Ranjith,Ruben,Frank & all other experts

I am really down with the issue of achieving my out put as per the case highlighted. Concatenation & all other attempts were failed. Since I need to have a proper application in resolving this issue, I am seeking my dear all to help me on this.

Thank in advance

Neville

Re: Omission of loop created & to achieve what is expected

dplr-rn — Wed, 10 Oct 2018 14:34:26 GMT

Nevile

the issue is the different levels of granularity between the tables.

your inline is PRODUCT_CODE, ACCOUNT_CODE

NRP BR_CODE , PRODUCT_CODE

while the FR table is BR_CODE, ACCOUNT_CODE

your visualization wants BR_CODE , PRODUCT_CODE

it doesn associate it self neatly within it self

i think you will need to use a generik key concept and link all of these dimensions together

check below

Generic keys

Re: Omission of loop created & to achieve what is expected

nevilledhamsiri — Wed, 10 Oct 2018 16:24:41 GMT

Dear Ranjith,

Thanks a lot for helping me out on this. Frankly speaking I have no much idea what you propose being done over my data set. If you don't mind could you check my data & provide me some working. I have no idea where & how to start this altogether. I have actually three tables & their dimensions

TB-Table: (ACCOUNT_CODE,BR_CODE,TYPE)

NRP-Table: (BR_CODE,PRODUCT_CODE)

IN LINE-Table (ACCOUNT_CODE,PRODUCT_CODE)

I have got some difficult calculations using In line data. If possible, while keeping that data as it is, are we having some alternatives to do on balance two tables. Sorry for troubles made, if possible please provide me some working with the places where such treatments to be made

Thanks a lot for your time to response me

Neville

Re: Omission of loop created & to achieve what is expected

dplr-rn — Wed, 10 Oct 2018 16:37:48 GMT

Not sure how i can help it is partly technical partly business question.

e.g. the question for you is how is 1 row in NRP BR_CODE,PRODUCT_CODE combination linked to which rows in TB ACCOUNT_CODE,BR_CODE

depending on that you create a link table (generic keys) for those combinations.

Re: Omission of loop created & to achieve what is expected

nevilledhamsiri — Wed, 10 Oct 2018 16:51:50 GMT

Ranjith,

What I need is to get NRP in one column calculated based on data in the TB Table & In line table & again get the NRP from cross table structure & to be matched. If I keep only one Branch data (RA or EH ) in the cross table, I get the NRP Figures separately in two columns & be matched. But once one more branch is added, results are produced with the addition of both Branches.

After all,

RA Code figures for each Product codes obtained from the formula to be placed against the same kind of figures obtained from cross table data.