Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
how to upload my data?
thanks
You can upload files with advanced editor (use button in the right upper corner when you reply).
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
i still not found that button, , i want to send to your mail, but your mail not appear, thanks
thanks before,
1. sheet4-2 : tbl-trans_medical
2. sheet4 : tbl_bmedical
3. sheet4-1 ; tbl_personal
-----------
jri: integer
jrj:integre
tgl_klaim: date
so
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