Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
Please post some sample data, with expected output
Qlik Community Tip: How to Get Answers to Your Post
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.