FirstSortedValue cannot be used in script

[ananyaghosh]

Hi,

I have done this thing:

Employee:

load * Inline [

Employee ID, Age, Customer Name, Sales

Sandip Ghosh, 34, Customer1, 1000

Ananya Ghosh, 29, Customer2, 1200

Amit Das, 35, Customer3, 3000

Kaushik Dhar, 55, Customer4, 5400

Sudhir Ghosh, 74, Customer5, 5980

Sandip Ghosh, 34, Customer6, 54670

Sandip Ghosh, 34, Customer7, 45675

Kaushik Dhar, 55, Customer8, 15400

Kaushik Dhar, 55, Customer9, 45400

Sudhir Ghosh, 74, Customer10, 6598

Ananya Ghosh, 29, Customer2, 16200

Sudhir Ghosh, 74, Customer5, 5980

Sudhir Ghosh, 74, Customer6, 2980

Ananya Ghosh, 29, Customer2, 12900

Ananya Ghosh, 29, Customer2, 12070

];

LET vHighestSalary = FirstSortedValue([Customer Name], -Sales);

SET vSalary =  'Highest Salary = ' & vHighestSalary;

Now show the variable in textbox object as =$(vSalary), but it only show  'Highest Salary = ' and value is not showing.

[ananyaghosh]

Can u tell me what is the use of double equals to(=) and $ sign here? or why I am using = sign insight the () ?

Please give an explanation with an example.

[anbu1984]

Check these links

The Magic of Variables

The Magic of Dollar Expansions

[Peter_Cammaert]

There is no double equal sign in my examples. Moreover, you won't need it.

This is the theory:

• The first equal sign is necessary for QlikVies to interprete the text as an expression (just like in Excel). First the text after the first equal sign will be evaluated as a regular QlikView expression and the result of evaluation will be used/displayed.
• $-sign substitution always comes before any evaluation.
• Usually a $(varname) construct will we replaced by the text value that is stored in variable varname. Varname can be prefixed by one of two 'modifiers':
  - a # means substitute with the numerical value of varname
  - a = means substitute with the result of evaluating the text after the equal sign (again an expression)

Best,

Peter