topic Re: Set analysis - division in QlikView

Set analysis - division

qliktech_uk — Thu, 14 Sep 2017 07:28:41 GMT

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)

Re: Set analysis - division

Kushal_Chawda — Thu, 14 Sep 2017 07:33:24 GMT

what is the Format of your month?

Re: Set analysis - division

Anil_Babu_Samineni — Thu, 14 Sep 2017 07:33:48 GMT

Normally, This?

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

With Variable, This?

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

Re: Set analysis - division

techvarun — Thu, 14 Sep 2017 07:35:32 GMT

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

Re: Set analysis - division

its_anandrjs — Thu, 14 Sep 2017 07:35:51 GMT

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)

Re: Set analysis - division

qliktech_uk — Thu, 14 Sep 2017 07:40:19 GMT

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

its_anandrjs — Thu, 14 Sep 2017 07:41:53 GMT

Another way try this also for latest month

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

Re: Set analysis - division

Kushal_Chawda — Thu, 14 Sep 2017 07:43:08 GMT

try this

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

Re: Set analysis - division

its_anandrjs — Thu, 14 Sep 2017 07:46:31 GMT

Then try this if Month is NUM field

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

Re: Set analysis - division

techvarun — Thu, 14 Sep 2017 07:50:27 GMT

FirstSortedValue(ReceivedFIles/SentFiles,-Month)

Re: Set analysis - division

sunny_talwar — Thu, 14 Sep 2017 08:21:15 GMT

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]))

Re: Set analysis - division

its_anandrjs — Thu, 14 Sep 2017 09:21:25 GMT

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

Regards

Anand

Re: Set analysis - division

qliktech_uk — Thu, 14 Sep 2017 12:22:03 GMT

thank you all for help.

Re: Set analysis - division

its_anandrjs — Thu, 14 Sep 2017 12:29:42 GMT

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.