how to dynamically update a field after load without reloading
Sorry i don't know how to put this together. Please see the attached qlikview document & screen shot in which i have a field called factor20 which is calculated in the following wayif(max(20-(IATP/((Day28Forecast/20))))=0,1,max(20-(IATP/((Day28Forecast/20))))) in the script. So now the field will have a definite value for each style color combination for example for Style =1441 and color=BLACK we will have a value of factor20=18.815784.. and now the issue is we will have a size list box which is the lowest level than that of Style and color. Please see attached screen shot for additional explanation of issue. please let me know in case of any questions. Also i have attached the qvw file too. Thanks for your help in advance.
Re: how to dynamically update a field after load without reloading
The reason behind this difference is the way the calculation is done. While loading the script, no selections are made in the size field, this results in the maximum value being store as factor20. However, wehn you make a selection on the
size field the available data for IATP is reduced, and hence you will get a different value.