topic Re: how to dynamically update a field after load without reloading in QlikView

how to dynamically update a field after load without reloading

Anonymous — Wed, 12 Mar 2014 14:42:30 GMT

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 way if(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

Anonymous — Wed, 12 Mar 2014 14:48:46 GMT

any help on this.

Re: how to dynamically update a field after load without reloading

Anonymous — Wed, 12 Mar 2014 14:59:13 GMT

any help

Re: how to dynamically update a field after load without reloading

srchilukoori — Wed, 12 Mar 2014 16:43:12 GMT

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.