Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashok555
Contributor III
Contributor III

greater than condition for select in field action (Date field)

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.

Sample.png

Exprn.png

So how do can make the above to work?

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi,

Try

='>'&Date($(=Today()-7))

Regards,

Antonio

View solution in original post

5 Replies
antoniotiman
Master III
Master III

Hi,

Try

='>'&Date($(=Today()-7))

Regards,

Antonio

Anil_Babu_Samineni

Seems, You have Number format and Today() returns the Date Format as always. Can you cross check the same

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
qlikviewnovice
Specialist II
Specialist II

Hi

Check the Date Format once

Kushal_Chawda

try this expression

='(' & concat( distinct if([Lead Created Date]>= today()-7,chr(39)&[Lead Created Date]&chr(39)),',') & ')'

ashok555
Contributor III
Contributor III
Author

Thank you very much Antonio Mancini..

It worked as expected.