I apologize first of all if I ask for elementary things.
The question is...i have a articulate database that contain a lot of information in different tabels.
I perfectly create the script that gives me all the information necessary to calculate what i want...but i have a lot of problems to create a dinamic table that give me instantly all the information to calculate the costs of a haemodynamic procedure.
Currently I have a table that provides in output the results as shown in the attached excel (SHEET 1-TEST_FROMAT_ACTUAL).
The result is provided by a qlik table configured as visible in the PDF attached screenshots_table_qlik
NOW I HAVE 2 OBJECTIVES:
Because each procedure have a different number of fields utilized...(es. is possible that there are 4 operator, 10 material utilized, 5 procedure executed....and in another procedure 2 operator, 5 material utilized, 3 procedure executed) ...I MUST CREATE A TABLE THAT DYNAMICALLY INSERT ONCE IN THE ID ROW ALL THE FIELDS (The desidered output is showed in the attached excel (SHEET 2-TEST_FROMAT_IDEAL).
Because the fields are entities without economic value, I have to calculate the value of each field a posteriori!!!
2.1 I must create a table or excel that assign an economic value to each field?? How I can do it and how i can insert this information inside the qlik table??
2.2. I have to be able to calculate every economic value as shown in the attached excel (SHEET 3-TEST_FROMAT_IDEAL_FINAL)...How i can put this information inside the qlik dashbboard?
I hope that someone can help me!!!
TY so much.