topic GROUP BY From A QVD Syntax in QlikView

GROUP BY From A QVD Syntax

rebelfox — Sat, 16 Nov 2024 00:44:51 GMT

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 — Sat, 02 May 2020 11:37:34 GMT

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 — Sat, 02 May 2020 12:52:37 GMT

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