Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set analysis differ in expression and script

Hi,

I am using

sum( {$<ProductID2 = {$(=max(ProductID2))} >} ListPrice )

in a chart expression and it works fine.

When I use the same code in a script I get an internal error in the {$(=max(ProductID2))} - part.

set vMySales = sum( {$<ProductID2 = {$(=max(ProductID2))} >} ListPrice )

How come it does not work the same way?

Kind regards

Peter

1 Reply
Not applicable

Re: Set analysis differ in expression and script

Hi,

I thought you always had to surround strings with double quotes in a SET statement.

Also: is your ProductID2 field available at the time of calculation?

Dion Verbeke

Sr BI Consultant