Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Combining Integer and date

Hi!

I'm trying to combine Integer '1234' and Date together.

I've tried everything but QV keeps changing my datatype to text.

Here's an example:

INTEGER&date(DATE,'YYYYMMDD') as FINALRESULT

I want FINALRESULT to be in Integer format not in String because I need to use Intervalmatch later.

Thank you!!!

-Mikael

3 Replies
Not applicable

Combining Integer and date

use something like:

num(date#())

erich_shiino
Honored Contributor

Combining Integer and date

Hi,

You can try this:

num(INTEGER&text(date(DATE,'YYYYMMDD')))

or

num#( INTEGER&date(DATE,'YYYYMMDD'), '000000000000)

Hope it helps,

Erich

Not applicable

Combining Integer and date

Thank you for your suggestions. I founf out that my Integer was 15 digits long and QV only supports 14 digits integers.