Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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...