Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
any help on this.
any help
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.