Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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