topic Re: Need Help in set-analysis! in QlikView

Need Help in set-analysis!

Mon, 12 May 2014 11:15:39 GMT

Hi ,

I need help in this expression

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

I believe this is what the expression does.

Sum of Actuals

Where:

_Source = "Application Approval Rate"

AND

Year =

{

Max of MonthYear

Where :

Actuals > 0

}

I need help on what is happening in the expression.

I presume it works like this,

Sum( {<condition 1, condition 2,...>}Actuals)

CONDITION USED IN THE ABOVE EXP: {< _Source = {"Application Approval Rate"}, Year = {'$(=Year(Max( { < Actuals = {">0"} >} MonthYear)))'}>}

_Source = {"Application Approval Rate"} - condition 1

Year = {'$(=Year(Max( { < Actuals = {">0"} >} MonthYear)))'} - condition 2

Now i need help with this part alone " Year = {'$(=Year(Max( { < Actuals = {">0"} >} MonthYear)))'} "

What does the above condition(expression) do ? Why is there a "$" in it ? Why is there a double quote in the first condition but only a single quote in the second condition ?

I am new to set analysis.

Thanks for the help.

Re: Need Help in set-analysis!

Colin-Albert — Mon, 12 May 2014 11:25:54 GMT

$(= .... ) tells QlikView to evaluate the expression that follows the equals sign and return the resulting data set.

The expression is surrounded by single quotes so the value returned is intrepreted as text.

The ">0" expression is a search expression, this is surrounded by double quotes to prevent the initial quote acting as a close quote for the earlier single quote.

Re: Need Help in set-analysis!

Mon, 12 May 2014 11:53:26 GMT

Hi,

for an actual String one quote is used. Double Quotes are generally used for wildcard Expressions (as you can see in your expression). I think the dollarsign here indicates that the expression in the brackets is evaluated.

Best regards

Martin

Re: Need Help in set-analysis!

c_gilbert — Mon, 12 May 2014 11:59:37 GMT

I sometimes use this Set Analysis wizard:

http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa

Hopefully it will help with your problem (or just to keep for future reference)