topic Combining Integer and date in QlikView

Combining Integer and date

Fri, 27 May 2011 11:25:13 GMT

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

Fri, 27 May 2011 11:28:42 GMT

use something like:

num(date#())

erichshiino — Sat, 28 May 2011 00:11:33 GMT

Hi,

You can try this:

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

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

Hope it helps,

Erich

Mon, 30 May 2011 05:57:28 GMT

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