topic Re: Select 2 Table in QlikView

Select 2 Table

Tue, 16 Sep 2014 03:29:55 GMT

Dear All,

thank for your attention

i have data on mysql, 2 table

1. tbl_personal, key ; id_emp { id_emp,name}

2. tbl_trans_medical, { id_emp,date_med,jri,jrj}

3. tbl_bmedical { id_emp, budget_jri, budget_jrj, budget_year}

jri & jrj : integer

so i want to select 3 tables, but i still confuse if using qlikview

in code mysql : select * from tbl_personal tp, tbl_trans_medical tt, tbl_bMedical tb where tp.id_emp=tt.id_emp and tp.id_emp=tb.id_emp

now i want to load in qlikview , in order to :

1. want to know sum jri dan jrj ever year group by id_emp

2. chart progress using budget medical

thanks for your help

- Akhrikas Andrias

Re: Select 2 Table

geert_gelade — Tue, 16 Sep 2014 03:49:46 GMT

You can just load the 3 tables in qlikview and the association will be automatically made on fields with the same name.

Script:

tbl_personal:

LOAD id_emp,name

SQL SELECT * FROM tbl_personal

tbl_trans_medical:

LOAD id_emp,date_med,jri,jrj

SQL SELECT * FROM tbl_trans_medical

tbl_bmedical :

LOAD id_emp, budget_jri, budget_jrj, budget_year

SQL SELECT * FROM tbl_bmedical

Once the data is loaded with the script, you can add calculations and charts.

If you upload your data, I can provide you with an example.

Re: Select 2 Table

sujeetsingh — Tue, 16 Sep 2014 04:00:43 GMT

Andrias,

It seems that you have ID_Emp as key for all.

You can use the concept suggested above and the association will work fine.

You need to do other changes and other key if your requirement uses some other functianality.

Re: Select 2 Table

Tue, 16 Sep 2014 04:17:22 GMT

how to upload my data?

thanks

Re: Select 2 Table

geert_gelade — Tue, 16 Sep 2014 04:19:44 GMT

You can upload files with advanced editor (use button in the right upper corner when you reply).

Re: Select 2 Table

Tue, 16 Sep 2014 04:21:42 GMT

yes, i have id_emp for 3 tables, but primary key just on tbl_personal

- tbl_personal ( table personal employee)

- tbl_trans_medical ( table transaction of medical every month)

- tbl_bmedical ( table budget medical for 1 year

so i want to join that table , inorder to know about sum of jri and jrj every person

Re: Select 2 Table

Tue, 16 Sep 2014 04:30:33 GMT

i still not found that button, , i want to send to your mail, but your mail not appear, thanks

Re: Select 2 Table

Wed, 17 Sep 2014 03:09:03 GMT

thanks before,

1. sheet4-2 : tbl-trans_medical

2. sheet4 : tbl_bmedical

3. sheet4-1 ; tbl_personal

-----------

jri: integer

jrj:integre

tgl_klaim: date

1. I want to know growth every person using jri and jrj on tgl klaim

if i coding in mysql this

select year(tgl_klaim) as yearclaim, month(tgl_klaim) as monthclaim, sum(jri), sum(jrj) from tbl_trans_medical tt group by year(tgl_klaim), month(tgl_klaim) order by year(tgl_klaim), month(tgl_klaim)

2. if i select one of person then display budget medical from tbl_bmedical ( brjalan, brinap),

so i must join that tbl_bmedical + tbl_personal+tbl_trans_medical ( like master detail data)

thanks for your attention