topic Re: how to remove loop in QlikView

how to remove loop

Anonymous — Tue, 23 Jul 2013 13:22:47 GMT

I want ask how to link "Accounts" and "Patients".But all dimension must link exactly from picture. The problem is between "Accounts" and "Patients" because the fields c and city,s and state,z and zip are the same.I don`t know how i link them without loop. Thank you

Re: how to remove loop

ariel_klien — Tue, 23 Jul 2013 13:29:12 GMT

Hi,

Use Concatenate in the script for some of your tables.

Ariel

Re: how to remove loop

Gysbert_Wassenaar — Tue, 23 Jul 2013 13:29:34 GMT

You'll have to rename L2 in either txBilling or Treat or rename MEDNO in either Treat or Patient or rename ACCTNUM in either Accounts or txBilling.

Re: how to remove loop

Tue, 23 Jul 2013 13:32:29 GMT

for removing loop

there are many ways--

1- by join between two tables

2- by chage alies that is rename the field name

3-- by use the concatenate between two tables

Re: how to remove loop

Anonymous — Tue, 23 Jul 2013 13:55:34 GMT

The problem is between "Accounts" and "Patients" because the fields c and city,s and state,z and zip are the same.I don`t know how i link them without loop. Thank you