GROUP BY From A QVD Syntax

[rebelfox]

I am confused by my attempt to load from a QVD using GROUP by to get the maximum value of a field.

In the code below the GROUP BY line is not highlighted in blue.

When I run the Qlikview I get the error:-

It all indicates the syntax is bad somehow.

 

 

[Vegar · Accepted solution]

1. Make sure your spelling is correct on tem_unit.

2. Add a (qvd) in the FROM, like this:

FROM .\Data\QV0029_ITEMS.qvd (qvd)

[rebelfox]

It was the (qvd) in brackets that solved it.  Thanks.  Much appreciated.