Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rsingh43
Contributor

Date Expression

Hi,

I am trying to exclude rows not required from my dataset but my expression does not seem to be working.

In data load editor I have created the below column:

IF(DATE(Exp_PODDate) = DATE(Today()),1,0) AS Exp_PODDateTODAY

I have then created the below expression using the above column:

=IF(Exp_PODDateTODAY = 1,Exp_PODDateTODAY)


Could someone please help with what I have done wrong?


Thanks


Tags (1)
1 Solution

Accepted Solutions

Re: Date Expression

date() is formatting function it will not round your date

try below

IF(DATE(floor(Exp_PODDate)) = DATE(Today()),1,0) AS Exp_PODDateTODAY



Regards,

Regards,
Prashant Sangle
5 Replies
jyothish8807
Honored Contributor II

Re: Date Expression

Hi Raman,

Can you share a sample data or an app?

Br,

KC

Best Regards,
KC
rsingh43
Contributor

Re: Date Expression

Hi KC,

I have attached qvf file of app.

thanks

Re: Date Expression

date() is formatting function it will not round your date

try below

IF(DATE(floor(Exp_PODDate)) = DATE(Today()),1,0) AS Exp_PODDateTODAY



Regards,

Regards,
Prashant Sangle
jyothish8807
Honored Contributor II

Re: Date Expression

Hi Raman,

As per the data, i dont see "Exp_PODDateTODAY" with value 1. All value is 0.

Once you have value as '1' just uncheck "Include null Values"  for  Exp_PODDateTODAY in the table.

Br,

KC

Best Regards,
KC
rsingh43
Contributor

Re: Date Expression

Thanks!

I have the column and used the below expression:

Sum({<Exp_PODDateTODAY = {1}>}Exp_PODDateTODAY)

Community Browser