topic Re: Expression isnt working in QlikView

Expression isnt working

samuel_brierley — Mon, 27 Jan 2014 11:08:24 GMT

Hi the below formula isnt working.

if(Date <= [Period 2 Start Date], 2,1)

regardless if i put < or > it still results in 1's?

thanks for any help

Re: Expression isnt working

Mon, 27 Jan 2014 11:12:20 GMT

did you check if both field have the same dateformat?

Re: Expression isnt working

Anonymous — Mon, 27 Jan 2014 11:14:20 GMT

Samuel

Are both your fields Date and [Period 2 Start Date] in the same format ?

You could try forcing them both to numeric :

if(num(Date) <= num([Period 2 Start Date]), 2,1)

Best Regards, Bill

Re: Expression isnt working

alexandros17 — Mon, 27 Jan 2014 11:15:53 GMT

When you manage date transform them with num

if(Num(Date) <= Num([Period 2 Start Date]), 2,1)

hope it helps

Re: Expression isnt working

Mon, 27 Jan 2014 11:16:07 GMT

try this

if(num(Date(Date)) <=num( Date([Period 2 Start Date])), 2,1)

Re: Expression isnt working

samuel_brierley — Mon, 27 Jan 2014 11:16:13 GMT

Yes they are both Date#(.....,'DD/MM/YYYY')

Re: Expression isnt working

samuel_brierley — Mon, 27 Jan 2014 11:23:42 GMT

all of my date fields where auto picked up by qlikview as dates but the Period 2 Start date wasnt so in the script i put

Date#([Period 2 Start Date],'DD/MM/YYYY')as [Period 2 Start Date],

that didnt help so i went back and did that to all Date fields but after i did that the old date fields that where already correctly formatted by qlikview now result in a number?majorly confused now?

Re: Expression isnt working

Mon, 27 Jan 2014 11:50:59 GMT

You must use:

Date(Date#([Period 2 Start Date],'DD/MM/YYYY'),'DD/MM/YYYY')as [Period 2 Start Date]