Discussion Board for collaboration related to QlikView App Development.
Hi,
I am trying to set a action for date field, it is working fine if i give the direct value but it is not working with greater than symbol.
So how do can make the above to work?
Hi,
Try
='>'&Date($(=Today()-7))
Regards,
Antonio
Seems, You have Number format and Today() returns the Date Format as always. Can you cross check the same
Hi
Check the Date Format once
try this expression
='(' & concat( distinct if([Lead Created Date]>= today()-7,chr(39)&[Lead Created Date]&chr(39)),',') & ')'
Thank you very much Antonio Mancini..
It worked as expected.