Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

how to trim Hour_Quarter_ID

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?

Tags (1)
2 Replies

Re: how to trim Hour_Quarter_ID

May be this:

LOAD *

FROM Source.qvd (qvd)

WHERE Hour_Quarter_ID >=201501010000 and Hour_Quarter_ID <=201512312359;

Re: how to trim Hour_Quarter_ID

LOAD *

FROM Source.qvd (qvd)

WHERE Hour_Quarter_ID BETWEEN >=201501010000 and <=201512312359;

Life is so rich, and we need to respect to the life !!!
Community Browser