Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
afshaarc
Contributor
Contributor
‎2019-01-29 10:43 AM

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?

 

 

 

Labels (1)
Labels
360 Views
0 Likes
0 Replies