Discussion Board for collaboration on QlikView Scripting.
Your requirement is still not that clear. If you want to upload sample data, I would reduce the size significantly. I suggest that you upload a qvw document showing what you have at the moment, and whet you need to achieve.
you can create derived dimension or calculated list box this will be getting calculated at object calculation time
but you can not physically store some field in your data on run time
Is COMMON and UNCOMMON are the user inputs? Until we know what the user inputs and what exactly he needs to see once he inputs something, we won't be able to help much.
The user input will be a numeric value based on which the field Trigger is validated using the condition IF((G2-AVERAGEIFS(B2:B10,F2:F10,"Yes"))>Sheet2!A1,"YES","NO")