Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)
It was the (qvd) in brackets that solved it. Thanks. Much appreciated.