Hi,
I am new to Qlik and need some help about creating a data set for the following scenario.
i have a patient table and each related information is stored in different tables like age, smoking, Medication, etc..
i neeed to create a report like
1. how many patients do not have Smoking recorded (if a patientId does not exist in Smoking table, he should be considered as not recorded)?
2. how many patients with age<18 and smoking not recorded?
3. How many patients have both Smoking and Medication recorded?
My solution was to Left join Patient table with all the remaining tables age, Smoking, Medication and so on.
But i have hundreds of tables and the Patient table will be huge.
Can someone help me with best possible solution in this scenario.
Patient:
Load * Inline
[
Id, Name
1, aa
2, bb
3, cc
4, dd
5, ee
6, ff
7, gg
8, hh
9, ii
10, jj
11, kk
];
Age:
Load * Inline
[
ID, Age, Sex
2, 5, F
3, 10, M
5, 35, M
7, 20, M
8, 25, F
];
Smoking:
Load * Inline
[
ID, SmokingCondition, Date
5, 9
6, 5
7, 1
8, 2
9,
];
Medication:
Load * Inline [
ID, Medication, Date
1, yes, 10/02/2015
2, No,
3, No,
4, Yes, 15/05/2017
5, Yes, 20/12/2016
];
