topic Re: need help in QlikView

need help

antonybi — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

I have two date columns with timestamp called closed date('DD-MM-YY hh:mm:ss tt') and deadline date('DD-MM-YY hh:mm:ss tt')

Now I have to create two flags
If ([closed date]<[deadline date],1,0) as flag1
If ([closed date]>[deadline date],1,0) as flag2

but not getting accurate results.

whats wrong with this.?

Pls help as so needful.

vishalarote — Mon, 14 May 2018 06:46:34 GMT

can you please share your qvw file and data source file ?

jyothish8807 — Mon, 14 May 2018 06:53:40 GMT

Hi Antony,

Try like this:

If (timestamp(timestamp#([created date],'DD-MM-YY hh:mm:ss tt'))<timestamp(timestamp#([deadline date],'DD-MM-YY hh:mm:ss tt')),1,0) as flag1

If (timestamp(timestamp#([created date],'DD-MM-YY hh:mm:ss tt'))>timestamp(timestamp#([deadline date],'DD-MM-YY hh:mm:ss tt')),1,0) as flag2

Br,

antonybi — Mon, 14 May 2018 06:55:34 GMT

actually am working on real data.

I have to create two flags based on these conditions.

– if the ticket is closed (Closed Date) before the deadline date

– if the ticket is closed (Closed Date) after the deadline date

am not getting accurate results because of timestamp.

How to handle this??

antonybi — Mon, 14 May 2018 07:11:50 GMT

Hi Jyothish,

I tried the same but still no luck.

jyothish8807 — Mon, 14 May 2018 08:26:37 GMT

CAn you share a sample format of the date fields you are loading ?

Also can you share your script ?

Br,

antonybi — Mon, 14 May 2018 10:28:14 GMT

Hi Jyothish,

I have removed timestamp# in your expression. Now it is working perfectly.

Thank u!

jyothish8807 — Mon, 14 May 2018 10:30:00 GMT

Cool