Expression Syntax

[#1]

Hi All,

Trying to get what is this expression :

Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}>}  Sales / $(vCurrency))

Not sure about symbols {,$,<.

Can you please help me out with following:

$(=Max(Year)-1): here we are taking 2 latest year but not sure why to use $.

Year={$(=Max(Year)), $(=Max(Year)-1)}>}  : not sure what exactly calculating here.

Sales / $(vCurrency) : where vCurrency = =Minstring(CURRENCY) , where currency field has vaules GBP,USD .....

                                 how sales can be divided by some string value.

Thanks in advance,

[#2]

Hi Mansi,

I think u very much new to the Set Analysis in Qlikview.

The Following symbols means:

$  :- sign represents the records of the current selection. The set expression {$} is thus the equivalent of not stating a set expression.

{< :- This is the way when you write the Set Analysis in the Expression.

{<......>}

$(vCurrency) if you are viewing the sample application please see their data model in that the CURRENCY field has value in the USDRate.

Regards,

Nitin Jain