Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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


1 Solution

Accepted Solutions
Highlighted

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,

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

5 Replies
Highlighted
Master II
Master II

Hi Raman,

Can you share a sample data or an app?

Br,

KC

Best Regards,
KC
Highlighted
Creator
Creator

Hi KC,

I have attached qvf file of app.

thanks

Highlighted

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,

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

Highlighted
Master II
Master II

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
Highlighted
Creator
Creator

Thanks!

I have the column and used the below expression:

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