I have the following qlikview app working with percentages hardcoded on the backend (script). The problem I have is that these percentages (called STAGE1_PERCENT and STAGE2_PERCENT) are supposed to be entered by user on the front end.
I have created inline tables for these percent variables in the script (to enable the user to choose any value between 0 & 100 for each of the STAGE1 and STAGE2 PERCENT variables, but there are quite a few calculations on the back end - which I am not able to do on the front end.
For example, I'm currently taking the START_DATE and END_DATE and calculating (using an ITER() function) the dates in between. This way, I can allocate the total HOURS supplied to me as HOURS per date ... which will eventually help me find if the HOURS were used in a particular quarter.
Is there a way to accomplish this on the front end after knowing the user entered STAGE1 and STAGE2 PERCENTS? I need these PERCENTS to calculate the DURATION for each stage, which inturn will dictate the START and END dates for each stage and also the dates included in between the start & end dates.
Please see the attached excel sheet for a sample of the data I have and the qlikview for what I currently have and make any suggestions to accomplish this with user entered STAGE1_PERCENT and STAGE2_PERCENT.
