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: 
qliktech_uk
Contributor III
Contributor III

Set analysis - division

Hi,

If I have to calculate sum(x)/sum(y) for the latest month in a text box would I have to do it this way

sum({<[Month ] = {'$(VMaxMonth)'}>}x) /sum({<[Month ] = {'$(VMaxMonth)'}>}y)

13 Replies
sunny_talwar

Are you doing this in a table where Month is a dimension? If this is true, then try this

Sum([Sent Files])/Above(Sum({<Month>}[Sent Files]))

its_anandrjs

I believe you get enough answers from the post can you please close the threads with appropriate answers for persons for references.

Regards

Anand

qliktech_uk
Contributor III
Contributor III
Author

thank you all for help.

its_anandrjs

In Month field what type of data you have kind check it seems NumMonth work here because Max(Month)) gives you numeric values kindly check this.