topic Calculate Date Value in QlikView

Calculate Date Value

Thu, 05 Nov 2015 14:12:34 GMT

I want to create a field that has the result of current date-scan date.

i.e; There is a field called Scan Date, which if doesn't fall within 21 days of current date, the result should be blocked, else unblocked. Tried different expressions but nothing is working.

Re: Calculate Date Value

Mark_Little — Thu, 05 Nov 2015 15:21:46 GMT

Hi,

I would add a flag in the load script.

Something like

IF(Today() - [Scan Date]) > 21, 0, 1) As showflag

then in your expressions you can just add {<showflag = {1}>}

Hope this helps

Mark

Re: Calculate Date Value

alexandros17 — Thu, 05 Nov 2015 16:27:36 GMT

Try with

If(Num(Today()) - Num([Scan Date]) > 21,

Num(Today()) - Num([Scan Date])

) As showflag

let me know

Re: Calculate Date Value

Thu, 05 Nov 2015 16:29:22 GMT

Sure, I tried the ones that were mentioned earlier. Will try this and let u know. Thanks

Re: Calculate Date Value

Thu, 05 Nov 2015 16:40:29 GMT

Can you give me the step by step how and where to do each step?

Re: Calculate Date Value

alexandros17 — Thu, 05 Nov 2015 16:44:11 GMT

Open the expression and write the following:

If(Num(Today()) - Num([Scan Date]) > 21,

Num(Today()) - Num([Scan Date])

)

Re: Calculate Date Value

Thu, 05 Nov 2015 16:52:21 GMT

Thanks Alessandro. This works.

Re: Calculate Date Value

alexandros17 — Fri, 06 Nov 2015 08:29:27 GMT

Could you please mark the answer? Thanks