Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to join fields to one in QV?

Hello,

I have date and time data stored in two separate columns in my datasource. In QV I'd like to concatenate them as one timestamp for gettting comparable timestamps. I quess this is possible, but can not figure out how? Definig a new variable maybe?

Thanks!

-dzeidzei

1 Solution

Accepted Solutions
Not applicable

Re: How to join fields to one in QV?

use this :

date(num(datefieldname) + frac(timestamp(timefieldname, hh:mm:ss')), 'DD/MM/YYYY hh:mm:ss')

Hope it helps.

Regards

5 Replies
Highlighted
er_mohit
Honored Contributor II

Re: How to join fields to one in QV?

are you trying to see date and time in one column??

plz can you clarify it with an example ? whats you want in output

Not applicable

Re: How to join fields to one in QV?

use this :

date(num(datefieldname) + frac(timestamp(timefieldname, hh:mm:ss')), 'DD/MM/YYYY hh:mm:ss')

Hope it helps.

Regards

Not applicable

Re: How to join fields to one in QV?

I have data in database columns like SOME_DATE whichc contaisns values in format dd.mm.yyyy and SOME_TIME with values in format hh:mm:ss. In QV I'd like to have one timestamp style field where thiose tvo separate feils should be joined to one timestamp SOME_TIMESTAMP with values in format dd.mm.yyyy hh:mm.ss

chauhans85
Esteemed Contributor

Re: How to join fields to one in QV?

try this out

date#(somedate&' '&sometime,'dd.mm.yyyy hh:mm:ss')

Hope this helps

Not applicable

Re: How to join fields to one in QV?

Thanks qlik_techie. That one did the trick.

Community Browser