Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am having 5 skills for each employee. (skill1, skill2,skill3,skill4,skill5). If I select skill 1, I need to get sum of skill selected in skill2,3,4,5.
Suppose I select Qlikivew as skill1 then I need count of employees having skill2,skill3,skill4,skill5 as Qlikview. How to achieve this.
Please assist ASAP.
Try this in a text object:
=Count({<SKILL1={'$(=GetFieldSelections(PRISKILL))'}, PRISKILL>}EMP)+
Count({<SKILL2={'$(=GetFieldSelections(PRISKILL))'}, PRISKILL>}EMP)+
Count({<SKILL3={'$(=GetFieldSelections(PRISKILL))'}, PRISKILL>}EMP)+
Count({<SKILL4={'$(=GetFieldSelections(PRISKILL))'}, PRISKILL>}EMP)+
Count({<SKILL5={'$(=GetFieldSelections(PRISKILL))'}, PRISKILL>}EMP)
Hi sahithya,
Your requirement is not clear. Can you explain in detail and some sample data?
Try like:
Count({<SkillField= - SkillField>} Distinct Employee)
I have a list box for PRISKILL. Suppose if I select 'A', then I need Employee count whose SKILL1,SKILL2,SKILL3,SKILL4,SKILL5 is 'A'.
@Treesco: Count({<SKILL1= GetFieldSelections(PRI_SKILL)>} Distinct Employee). But its not working.
Please help me.
An extension/alternate to what tresesco suggested, we may define two alternate states say "UI" and "background". All UI list boxes will be on UI and on selection of SkillField (with UI state), we set SkillField (with background state) using a trigger and Select Excluded function. Finally use Count({background} SkillField) in the final expression.
Try to share a sample qvw(explaining the desired output) where it can be worked upon.
I am using Qlikview Personal Edition.
Its ok, Attach the file.
Try this in a text object:
=Count({<SKILL1={'$(=GetFieldSelections(PRISKILL))'}, PRISKILL>}EMP)+
Count({<SKILL2={'$(=GetFieldSelections(PRISKILL))'}, PRISKILL>}EMP)+
Count({<SKILL3={'$(=GetFieldSelections(PRISKILL))'}, PRISKILL>}EMP)+
Count({<SKILL4={'$(=GetFieldSelections(PRISKILL))'}, PRISKILL>}EMP)+
Count({<SKILL5={'$(=GetFieldSelections(PRISKILL))'}, PRISKILL>}EMP)
Velasco, I worked. Thank you