How to develop a Qlikview app?

[#1]

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‌ !

[vinieme12]

Please post some sample data, with expected output

Qlik Community Tip: How to Get Answers to Your Post

[#3]

	EMP_FNAME	EMP_NO	Primary_skills	subskills_1	subskills_2
	Aakash Bhagwan	471855	Informatica	DW	SSIS
	Aayta	262151	.net	Data Network	.Net Framework
	Abdul Bari Mohammed Talha	457449	Java	Java Enterprise - Front End	Java Enterprise - Back End
	Abhijeet Uddhav	359410	DW	Qlikview	-
	Abhijit Prabhakar	463855	Python	Mainframe Testing	Mobile Application Testing
	Abhinay	444434	Java	Java Enterprise - Front End	EJP
	Abhishek	350917	Informatica	DW	SSIS
	Abhishek	452867	Java	Java Enterprise - Front End	Java Enterprise - Back End
	Abhishek	464076	.net	Data Network	.Net Framework
	Abhishek Vijay	458739	DW	Qlikview	Qliksense
	Abily	315650	Python	Mainframe Testing	Mobile Application Testing
	Abinash	492186	Java	-	-
	Abirami	364005	Informatica	DW	SSIS
	Abisha	440587	.net	Data Network	.Net Framework

This is the sample data.For now I want to display the below.

EMP_NO	Name	Fitment
471855	Aakash Bhagwan	100
262151	Aayta	100
463855	Abhijit Prabhakar	100
34066	Rajkumar Soundararajan	100
359410	Abhijeet Uddhav	75
492186	Abinash	50

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.