Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rebelfox
Creator
Creator

GROUP BY From A QVD Syntax

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.

SimpleCode.jpg

 

When I run the Qlikview I get the error:-

Capture2.JPG

It all indicates the syntax is bad somehow.

 

Labels (1)
1 Solution

Accepted Solutions
Vegar
Partner
Partner

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)

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Vegar
Partner
Partner

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)

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

rebelfox
Creator
Creator
Author

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