topic Re: Help with expression in QlikView

Help with expression

Anonymous — Fri, 09 Oct 2015 16:10:55 GMT

Hi guys,

I have the following in SQL

datediff(dd,due_date,getdate()) between '1' and '30' - This is basically doing between 1 and 30 days from today..

Can I recreate this as an expression?

Thanks

villegasi03 — Fri, 09 Oct 2015 16:13:16 GMT

try networkdays(today(), due_date)

Gysbert_Wassenaar — Fri, 09 Oct 2015 16:13:31 GMT

if( interval(due_date - today(), 'd') >=1 and interval(due_date - today(), 'd') <= 30, 'True', 'False')

pamaxeed — Fri, 09 Oct 2015 16:13:38 GMT

Interval(now() - due_date,'DD') as DaysDiff

look in the HELP section about interval function...very powerful in Qlikivew

Cheers,

Patric

Anonymous — Mon, 12 Oct 2015 15:51:29 GMT

Thanks for all your help as always guys.. I used Patric's solution in the end