Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

dynamically changing input boxes with respect to input

Hi All,

I'm trying to create input boxes which enables user to input the value which would change the required and output quantities.

Eg:

Units/Hr. Expectation124

Hrs/worker  = 8.5

Units to be completed78,998

No. of hours required to complete the available units = 78998/124 = 637.08

No. of workers required = 637.08/8.5  ~ 75

In the attached application,

i would like to allow user to enter the value for any of the parameters (units to be completed (or) hours req. (or) workers req)

so the user can see the pro rated values when one of the value is changed.

Any help is highly appreciated.

1 Solution

Accepted Solutions
Highlighted

May be this:

='Units/Hr. Expectation' & vUnits & Chr(10) &

'Hrs/worker  = ' * vHours & Chr(10) &

'Units to be completed' & vWorkers & Chr(10) &

'No. of hours required to complete the available units = ' & vWorkers & '/' & vUnits & ' = ' & Round(vWorkers/vUnits, 0.01) & Chr(10) &

'No. of workers required = ' & Round(vWorkers/vUnits, 0.01) & '/' & vHours & ' ~ ' & Round(vWorkers/vUnits/vHours)

View solution in original post

2 Replies
Highlighted

May be this:

='Units/Hr. Expectation' & vUnits & Chr(10) &

'Hrs/worker  = ' * vHours & Chr(10) &

'Units to be completed' & vWorkers & Chr(10) &

'No. of hours required to complete the available units = ' & vWorkers & '/' & vUnits & ' = ' & Round(vWorkers/vUnits, 0.01) & Chr(10) &

'No. of workers required = ' & Round(vWorkers/vUnits, 0.01) & '/' & vHours & ' ~ ' & Round(vWorkers/vUnits/vHours)

View solution in original post

Highlighted
Specialist
Specialist

That's perfect sunny.

I was doing some error in Round () and calculation.

You nailed it

Thanks again.