I am trying to develop a app for resume search in Qlikview.I have a source data with employee details with their skillset.Based on my search I have to give fitment percentage.For example if I want a profile with java skill I will give fitment percentage as 100 for the matching profiles.How to calculate percentage for this case? Please help jagan !
This is the sample data.For now I want to display the below.
I done this by using simple If else statement.
i.e, If (primary_skills = java,50 )
if(subsill1 = 'java front end',25)
if(subsill1 = 'java back end',25)
and I have to calculate the total fitment percentage.This is working fine but If the primary skills and secondary skills are included more I have to edit the script according to the requirement.Instead of editing that I want it to be automatically calculated.Instead of writing it in simple if else is there any other option to do this.