Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Replace the semicolons after Discount and after GrossRevenue with comma's
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.
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??
Replace the semicolons after Discount and after GrossRevenue with comma's
Hi Gysbert
Thank you for the assistance this has worked