how to trim Hour_Quarter_ID

[#1]

I have QVD files and for viewing the content inside it I just do drag and drop the qvd on Qlikview so I am able to see the content of qvd.

Here I want to trim my Hour_Quarter_ID in >=201501010000 and <=201512312359

So can anyone explain this in detail that how to do it while drag and drop qvd onto qlikview?

[sunny_talwar]

May be this:

LOAD *

FROM Source.qvd (qvd)

WHERE Hour_Quarter_ID >=201501010000 and Hour_Quarter_ID <=201512312359;

[Anil_Babu_Samineni]

LOAD *

FROM Source.qvd (qvd)

WHERE Hour_Quarter_ID BETWEEN >=201501010000 and <=201512312359;