topic Re: Explanation Required in QlikView

Explanation Required

Wed, 30 Apr 2014 07:11:56 GMT

Can anyone please explain the expression given below?

Sum( {< _Source = {"Application Approval Rate"}, Year = {'$(=Year(Max( { < Actuals = {">0"} >} MonthYear)))'}>} Actuals)

Re: Explanation Required

its_anandrjs — Wed, 30 Apr 2014 07:17:35 GMT

From above expression

Where your Actuals is >0 then you get Max valye of MonthYear and get Year from the MonthYear field and compare it to the Year field and also checks _Source = Application Approval Rate then Sum the Actuals.

Your Expression has parts like

1. For Sum Actuals Sum( Actuals)

2. Where _Source = {"Application Approval Rate"} Means _Source = Application Approal Rate.

3.Where your Year = Max(Year) which is calculated by Year = {'$(=Year(Max( { < Actuals = {">0"} >} MonthYear)))

4. If all condition satisfied then calculate the Sum(Actuals) by the expression

Sum( {< _Source = {"Application Approval Rate"}, Year = {'$(=Year(Max( { < Actuals = {">0"} >} MonthYear)))'}>} Actuals)

Re: Explanation Required

MK_QSL — Wed, 30 Apr 2014 07:21:58 GMT

Sum( {< _Source = {"Application Approval Rate"}, Year = {'$(=Year(Max( { < Actuals = {">0"} >} MonthYear)))'}>} Actuals)

SUM(Actuals) Will give you sum of Actuals

Where

1) _Source = Application Approval Rate

2) Year = Max Year (i.e. Year = Max(MonthYear)

Where a) Actuals > 0

Hope this helps...

Re: Explanation Required

qvwarning — Wed, 30 Apr 2014 07:24:56 GMT

Hi,

the expression sums the dimension Actuals

based on the current selection

where the _Source field has a value Application Approval Rate

and the Year are the last possible (Max) of 'MonthYear' for Actuals greater then 0.

Andreas

Re: Explanation Required

Wed, 30 Apr 2014 07:35:18 GMT

Sum of Actuals

Where:

_Source = "Application Approval Rate"

AND

Year =

{

Max of MonthYear

Where :

Actuals > 0

}

Re: Explanation Required

Wed, 30 Apr 2014 07:36:22 GMT

Thank you all for your help

Re: Explanation Required

MK_QSL — Wed, 30 Apr 2014 08:13:02 GMT

Please close the thread by selecting appropriate answer so that others can also take benefit.

Re: Explanation Required

MK_QSL — Wed, 30 Apr 2014 09:58:54 GMT

I also gave the same answer

Re: Explanation Required

its_anandrjs — Wed, 30 Apr 2014 10:04:20 GMT

Did you check my answer also that is also same.

Re: Explanation Required

preminqlik — Wed, 30 Apr 2014 10:12:14 GMT

you kow manish , i think gaurav sharma is from india ....... here also ladies reservation works....:)

Re: Explanation Required

MK_QSL — Wed, 30 Apr 2014 10:14:37 GMT