Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Highlighted
Valued Contributor III

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
Highlighted
Valued Contributor III

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

any help on this.

Highlighted
Valued Contributor III

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

any help

Valued Contributor

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

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