topic Re: Using Today()-30 in QlikView

Using Today()-30

navaneeth79 — Mon, 05 Feb 2018 11:44:09 GMT

Hi all,

I am using if(Submit_Date <= Today()-30,Submit_Date)

I am not getting the values 30 days and older records in the table but its displaying all available records. I want only 30 days or older records.

Re: Using Today()-30

its_anandrjs — Mon, 05 Feb 2018 11:51:47 GMT

Try this use Date to convert numeric date

if(Submit_Date <= Date( Today()-30 ),Submit_Date)

Re: Using Today()-30

sunny_talwar — Mon, 05 Feb 2018 12:37:18 GMT

Have you added all the dimensions/fields you need to see in the chart? And also, select 'Suppress When Value Is Null' for the above dimension on the dimension tab?

Re: Using Today()-30

navaneeth79 — Mon, 05 Feb 2018 14:07:28 GMT

I have added all the required dimensions

Re: Using Today()-30

sunny_talwar — Mon, 05 Feb 2018 14:12:49 GMT

and what happened?

Re: Using Today()-30

navaneeth79 — Mon, 05 Feb 2018 14:19:51 GMT

if condition not reflecting in the chart

Re: Using Today()-30

sunny_talwar — Mon, 05 Feb 2018 14:26:01 GMT

Would you be able to post a sample or an image to show what you are seeing?