topic Re: Formula Error in My First Application in QlikView

Formula Error in My First Application

Tue, 30 Jul 2013 15:33:25 GMT

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

Re: Formula Error in My First Application

Gysbert_Wassenaar — Tue, 30 Jul 2013 16:21:15 GMT

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.

Re: Formula Error in My First Application

Tue, 30 Jul 2013 16:33:57 GMT

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??

Re: Formula Error in My First Application

Gysbert_Wassenaar — Tue, 30 Jul 2013 16:43:54 GMT

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

Re: Formula Error in My First Application

Wed, 31 Jul 2013 09:20:51 GMT

Hi Gysbert

Thank you for the assistance this has worked