Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qliktech_uk
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

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

Re: Set analysis - division

what is the Format of your month?

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 !!!
techvarun
Valued Contributor II

Re: Set analysis - division

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

Re: Set analysis - division

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

Load

*,

Num(Month(DateField)) as NumMonth

From Source;

On the UI try this

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

qliktech_uk
New Contributor III

Re: Set analysis - division

How do we use this function in this case

consider the following data

Month   SentFiles        ReceivedFIles

1            100                       90

2             200                     100

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

Re: Set analysis - division

Another way try this also for latest month

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

Re: Set analysis - division

try this

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

Re: Set analysis - division

Then try this if Month is NUM field

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

techvarun
Valued Contributor II

Re: Set analysis - division

FirstSortedValue(ReceivedFIles/SentFiles,-Month)

Community Browser