Formula Error in My First Application

[#1]

Hi

I am new to QlikView and I am just looking to learn the tool as my parent company have just adopted it as our central BI system.

I am trying to work through the "How to Build your First QlikView Document" however on page 23 the formulae specified just does not work.  

Can someone please assist, I have followed this word for word but it just does not work.

The formula is the text highlighted in red below, however when you reload it errors with an Invalid Statement error. 

OrderDetails:

LOAD OrderID,

    ProductID,

    UnitPrice,

    Quantity,

    Discount;

    (UnitPrice*Quantity) as GrossRevenue;

    ((UnitPrice*Quantity) - ((UnitPrice*Quantity)*discount)) as NetRevenue;

SQL SELECT *

FROM `Order Details`;

If anyone can assist I would be most greatful.  I have attached the PDF instruction although these can also be downloaded off the website.

Thank in advance

[Gysbert_Wassenaar]

Qlikview is case sensitive in most places. So Discount and discount are different things to Qlikview. If you change discount to Discount in the NetRevenue formula it should work.

[#3]

Hi Gysbert

Thanks for the quick reply.   Unfortuneatly this did not work and I still receive the two script errors you can see below.

Any other ideas??

[Gysbert_Wassenaar · Accepted solution]

Replace the semicolons after Discount and after GrossRevenue with comma's

[#5]

Hi Gysbert

Thank you for the assistance this has worked