Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
afshaarc
Contributor
Contributor

Division

Hi,

I am new to QlikSense and trying the below formula to divide two fields and not able to get the correct answer. 

num(sum({<$(VComparePeriod)>}"Sales")/Sum({<$(VComparePeriod)>}"No. of days"),'#.00%')

This formula gives same output/answer for all the days, weeks and months which does not match the pivot. 

Tried the formula without variables as well, it throws an error.

Can someone please help?

 

 

 

0 Replies