Expression Syntax

Wed, 07 Dec 2011 08:36:12 GMT

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,

Wed, 07 Dec 2011 08:56:34 GMT

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

topic Expression Syntax in QlikView