# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

#### Breathe easy -- you now have more time to plan your next steps with Qlik! QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Highlighted 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