topic End Date Alert in QlikView

End Date Alert

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I would like to display the number of days left and alert symbol when Warranty End Date is 2 days before Today's Date.

I tried by giving Today() - Warranty End Date but its giving some random value as 45545..Kindly Help !!!

Re: End Date Alert

Anonymous — Mon, 18 Apr 2016 14:59:52 GMT

So it doesnt show this "random value" like you've just mentioned, try entering the function Date. It should be something like:

Date(Today() - Warranty End Date)

Re: End Date Alert

Gysbert_Wassenaar — Mon, 18 Apr 2016 15:58:31 GMT

Dates are numbers too. Try this for example in a textbox: =Today(). You'll see today's date in your documents default date format. Next try =num(Today()). You should now see the numeric value of today's date, i.e. 42478.

If you get 45545 if you subtract your Warranty End Date value from Today() then you have a very funny value in your Warranty End Date field. You might want to check if that field really contains dates or only text values that only look like dates. Perhaps you should use the date#() function in the load script to turn text values into real date vales.