Discussion board where members can get started with QlikView.
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.
use something like:
You can try this:
num#( INTEGER&date(DATE,'YYYYMMDD'), '000000000000)
Hope it helps,
Thank you for your suggestions. I founf out that my Integer was 15 digits long and QV only supports 14 digits integers.