Spotfire limit data using expression by dynamic date

[Joost Mulder]

How do I filter a visualisation on a date input

The Column DT and the property fromDate are of type Date.

This expression gives an error:

if([DT] > ${fromDate},true,false)

This expression does not give an error, but selects all dates and thus is not working correctly:

if(Date([DT]) > Date(${fromDate}),true,false)

How can I limit the data using a date input property

[Kirsten Smith (she/her)]

First, confirm that you set up the property control with a datatype of 'Date' and not Sting or some other type.

 

Next, try replacing:

${fromDate}

with:

DocumentProperty("fromDate")

[Joost Mulder]

Thanks KirstenS, DocumentProperty("fromDate") does the trick! :D