Hi All,
I have some columns in source excel file, Emp ID ,Gender , Tenure, Division, Salary. Now I need to implement below functionality:
This includes a listbox from where employee ID will be selected , multilple select dropdown from where one or more options will be selected , KPI chart on which result of calculation will be
On a QS sheet I've a filterpane chart, in which only one Emp ID will be selected. Once the EmpID is selected, then for further selection user has to select one or more options from multiple select dropdown which will be Gender, Tenure, Division.
If user has selected EmpID: 123 and in multiple select dropdown he has selected 'Gender' then, suppose if gender of emp 123 is Male, then sum(salary) of all such employees from source excel file whose gender is male should apprear on KPI chart.
My question is, since I'm new to QLIK can anyone help me with the query that needs to be written to implement this functionality and also suggest me where should I write it in data load editor or in expression if KPI.
I tried this expression but it's not working,
Sum({<EmpID ={GetFieldSelections(EmpID)},Salary}) / Sum({Gender = P(Gender)},Salary)
PS: Since we don't have multiple select in QS I've implemented it using Inline command as follows and to give it a look of multiple select I've taken a filter pane chart selected EMPinfo and gave it checkbox mode appearance.
Any suggestions are much appreciated.
Employee:
load * inline
[
EmpID,Empinfo
1,Gender
2,Division
3,Tenure
];
