Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Do While loop

I have ship dates that the user can select and as they select it changes the values of another field in a chart. The goal is for this field value to be equal or greater than another value, which is calculated. The user has requested that I automate this process so when the calculated field value is set, the ship dates are advanced until the chart field is equal to or just greater than the calculated field. Can anyone assist me with the script that would do this?

Message was edited by: James Walsh

20 Replies
JonnyPoole
Former Employee
Former Employee

A sample would help.  Can u share a QVW ?

Not applicable
Author

How do I share it? Is it as simple as copy and paste?

James F. Walsh Jr.

MIS

ME Elecmetal

(218) 213-9571

JonnyPoole
Former Employee
Former Employee

In your reply , go into the 'advanced editor' and from there you can attach a file.

Not applicable
Author

When I go into my message and select reply, I do not see an "Advanced

Editor"?

James F. Walsh Jr.

MIS

ME Elecmetal

(218) 213-9571

Not applicable
Author

I thought I figured out how to attach but I do not see it?

Not applicable
Author

It is attached to the original entry.

Not applicable
Author

"Net Tons to Pour", based on user values for "Net Tons per Day to Pour" and "# of Pour Days", is calculated and when "Net Good Tons" is equal to or greater than "Net Tons to Pour", "Pour Date" selection should stop. Currently, once I have a value for "Net Tons to Pour", I start selecting "Pour Date" and guess when "Net Good Tons" might be close to "Net Tons to Pour". The user has asked if I can automate this so once "Net Tons to Pour" is calculated, "Pour Date"s are selected until "Net Good Tons" is no long less than "Net Tons to Pour".

JonnyPoole
Former Employee
Former Employee

I changed the 'Pour Date' list box to an expression;

=if ( (TonsperDay*PourDays) <=  aggr(  Sum ((([Each Weight])/2000)*[To Pour Qty.]), [Pour Date]), [Pour Date])

It means that [Pour Date] will only show if 'Net Tons to Pour' is less than or equal to 'Net Good Tons'

I also added a list box expression whic shows 'net good tons' so the user has an idea of the threshold and what further filtering may yield.

also attached is the QVW sample.  Did i get this right ? I couldn't be 100% after reading your explanation. ! !

Capture.PNG.png

Not applicable
Author

But I still need to show Net Good Tons broken out by Metal Type (Alloy). Do I need to add the Pour Date expression to my to charts that are already on the page?