Could you please pour your suggestion on the below Scenario.
I am developing Qlikview app (Manual Excel data calculation into Qlikview Automated).
There is a field in Excel called Quality and Deliver (See Below the screenshot), For every ID the there is grading(High,Low Medium ) and each grading have a value as HIgh = 2 ,Low =3 Etc..). The theme is to bring the calculation field called Risk_Grading. The calculation in excel is like.. (Grading value * weight) for every Id. How to implement this in Qlikview.
I have loaded the excel fields in the Qlikview and named as Quality Grading,Delivery grading .How to bring weight value and high value inside the script
Sorrry.. Let be more simple. If you see there is a field in Excel like Quality, Under Quality there is again two fields Grading and Comment. In Qlikview i have loaded this Grading and Comment field and named as Quality grading and Qualtiy Comment ( I am not sure how to load in Qlikview exactly as in Excel). I want to assign a weight value for Qualtiy grading field. There are many values under Qualtiy grading Filed like low , risk and high to every ID.
I need to bring a field by multiplying the weight * Quality Granding Filed value (High,low etc) Where High, low and medium value would be hardcoded