# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
New 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)

Tags (1)
1 Solution

Accepted Solutions
MVP

## Re: Set analysis - division

Normally, This?

Sum({<Month = {'\$(=Max(Month))'}>} (x/y))

With Variable, This?

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

Life is so rich, and we need to respect to the life !!!
13 Replies
MVP

## Re: Set analysis - division

what is the Format of your month?

MVP

## Re: Set analysis - division

Normally, This?

Sum({<Month = {'\$(=Max(Month))'}>} (x/y))

With Variable, This?

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

Life is so rich, and we need to respect to the life !!!
Valued Contributor II

## Re: Set analysis - division

you can also use FirstSortedValue function. A sample data would be helpful here

MVP

## Re: Set analysis - division

Did you have num month field if not please introduce in data model

*,

Num(Month(DateField)) as NumMonth

From Source;

On the UI try this

sum({<NumMonth = { "\$(=Max(NumMonth)" }>}x)  / sum({<NumMonth = { "\$(=Max(NumMonth))" }>}y)

New Contributor III

## Re: Set analysis - division

How do we use this function in this case

consider the following data

1            100                       90

2             200                     100

I want to get the month 2 data in this format 100/200.

MVP

## Re: Set analysis - division

Another way try this also for latest month

sum({<NumMonth = { "\$(=Num(Month(Today()))" }>}x)  / sum({<NumMonth = { "\$(=Num(Month(Today())))" }>}y)

MVP

## Re: Set analysis - division

try this

sum({<[Month ] = {"\$(=max(Month))"}>}x) /sum({<[Month ] = {"\$(=max(Month))"}>}y)

MVP

## Re: Set analysis - division

Then try this if Month is NUM field

sum({<[Month ] = {"\$(=max(Month))"}>} ReceivedFIles) / sum({<[Month ] = {"\$(=max(Month))"} >} SentFiles)

Valued Contributor II