Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
HereWeGoAgain
Contributor III
Contributor III

Variable Input Box forecasts based on Revenue

Good Day

I would like to build two Variable input Boxes namely:

 - Total Working Days
- Total Days Worked

I would like to Select the "Year/Month" and then enter the current amount of days worked thus far as well as the total working days for that specific month.

After the two values are entered it need to calculate the forecasted revenue for the month.

eg.

Total working Days: 22
Total Days Worked: 5

Forecasted Revenue =(Revenue/5)*22

HereWeGoAgain_0-1638188986942.png

 

1 Reply
abhijitnalekar
Specialist II
Specialist II

Hi @HereWeGoAgain ,

I hope you are looking the same as below.

abhijitnalekar_0-1638211738383.png

I have attached the QVF file for reference.

 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!