applying property control drop down to visualisations

[Isabella Sharpley]

Hi,

I want to control the data making a table and chart by being able to select a single date.

To do so I have addd a drop down property control in a text area.

However now I am having difficulties in applying this property control to the visualizations. When I try to limit data (in the data properties) Iusing the expression , [DATE] = ${Date}, i get the error , "Invalid type for function call '=' ..."

How can I fix this

Thanks

[Shandilya Peddi]

Can you try the following and verify if it works

[Date]=DocumentProperty("Date")

 

That is instead of ${Date} useDocumentProperty("Date")

[Isabella Sharpley]

That did the job, thanks Shandilya!

 

BTW,  is there a way to order the property control dates to be in descending order in the dropdown

 

 

 

 

[Shandilya Peddi]

There is no way currently to control the order of values in the property control. I would suggest you file an enhancement request for that feature in the Ideas portal linked above: http://ideas.tibco.com/