Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 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.

3 Replies
Anonymous
Not applicable
Author

any help on this.

Anonymous
Not applicable
Author

any help

srchilukoori
Specialist
Specialist

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  factor20.png

size field the available data for IATP is reduced, and hence you will get a different value.