I would like to swtich off the legend of a visualization with a dropdown property control, which has fixed values True and False respectively, however, I used the script below but

[Stanley Wei]

Dear All,

 

I would like to swtich off the legend of a visualization with a dropdown property control, which has fixed values True and False respectively, however, I used the script below but it doesn't work, here are the full codes:

 

# Hide or Show legend# Stanley Wei, May-25 2015from System.Windows.Forms import FolderBrowserDialog,MessageBoxfrom Spotfire.Dxp.Application.Visuals import TablePlot, HtmlTextArea, VisualTypeIdentifiersfrom Spotfire.Dxp.Application.Visuals import VisualContent

 

for vis in Application.Document.ActivePageReference.Visuals:

if vis.Title == "Resources allocation trend (FTE)" : rt=vis.As[VisualContent]() MessageBox.Show(Document.Properties["cbxSwitchLegend"]) rt.Legend.Visible=Document.Properties["cbxSwitchLegend"]

If I used the abosulte value True of False instead of the Property control, it will work. Any thoughts about this question

 

Thanks a lot,

Stanley

[Manoj Chaurasia]

Thanks, Jots, you are right, I just used the default STRING property, now it works when I changed it to Boolean.

[Surekha Kasar 3]

Since you are planning to directly assign the document property, is the data type of Document Property boolean

[Surekha Kasar 3]

Glad it helped!

[gurusai sankar]

Hi Anonymous,could you please help on below spotfire queryhttps://community.spotfire.com/questions/how-get-grand-total-value-all-rows-or-else-how-fix-empty-values-all-rows-except-grand