Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I'm trying to round a value to 2 decimal places using a variable for the value without much success. What am I missing?

I've got a variable called  vAvgCallsPerHour which is a calculation stored as a variable so that if it changes, I only have to make one change which works fine

Calculation

3600/(Sum({<explanation={AMBWrapUp,ACDCallWrapup}>}duration)/sum({<explanation={ACDCallWrapup}>}Count)+Sum({<explanation={ACDAgentPicked}>}duration)/Sum({<Type={InboundCall}>}Count))

I then need to display this value in a text box  which I do by using '=$(vAvgCallsPerHour)' but this is displayed to approx 10 decimal places.


I've tried using =num($(vAvgCallsPerHour),'##.##') and the syntax checker seems happy enough but when I click ok I get ' Error: Error in expression: ')' expected


If I remove the dollar expansion i just get a -

What am I doing wrong?


Thanks

1 Solution

Accepted Solutions
colin_albert

Add the num() expression around the variable declaration.

Remember num() is just a formatting expression to truly round the value use round(xxx, 0.1), ceil(xxx, 0.1) or floor(xxx, 0.1)

Let vAvgCallsPerHour = num(3600/(Sum({<exp...InboundCall}>}Count)), '##.##') ;

View solution in original post

4 Replies
colin_albert

Add the num() expression around the variable declaration.

Remember num() is just a formatting expression to truly round the value use round(xxx, 0.1), ceil(xxx, 0.1) or floor(xxx, 0.1)

Let vAvgCallsPerHour = num(3600/(Sum({<exp...InboundCall}>}Count)), '##.##') ;

View solution in original post

puttemans
Specialist
Specialist

Hi Gavin,

Best would be to use Round.

Round(3600/(Sum({<explanation={AMBWrapUp,ACDCallWrapup}>}duration)/sum({<explanation={ACDCallWrapup}>}Count)+Sum({<explanation={ACDAgentPicked}>}duration)/Sum({<Type={InboundCall}>}Count)),0.01)

Not applicable
Author

use:

Round( (3600/(Sum({<explanation={AMBWrapUp,ACDCallWrapup}>}duration)/sum({<explanation={ACDCallWrapup}>}Count)+Sum({<explanation={ACDAgentPicked}>}duration)/Sum({<Type={InboundCall}>}Count))), 0.10)

Not applicable
Author

You're a genius! Worked a treat.. Thank you