Instead of defining the measure field under Measure section of Direct Query, please define it as Dimension. Then you can use it as Dimension as well as a measure.
Here Quantity is defined as dimension.
Thanks fro your reply but I'm afraid that is not going to work. From the documentation:
A Dimension field can be thought of as a regular in memory field, all of the data and metadata is
loaded into QlikView and the field is available to be used for associating the Direct table to other in
memory tables. All dimension fields are defined after the DIMENSION keyword within the script and
precedes the measures.
The dimension field is used for associating so it should already be in the datamodel. Is there any other way to use a direct discovery measure as a dimension in a chart?
take this approach:
make all your dimensions inline inside the qvw.
Test it and then tell me if it works.
Don´t forget to read well and carefully:
Hope it helps