You can also return to the Visual Analytics home page by clicking the application name "SAS Visual Analytics- Explore and Visualize" in the toolbar at the top of the application. From there you can browse and open reports, and switch between the reports you already have open.   ... View more

Thanks for sharing an example value. I'm not sure I understand what you want to accomplish with your IF statement: IF (GetWord('Loan Account No'n)>0)   What would be some values that would fail this check, if it was working like you wanted it to? Are you checking for missing values, or values that would just be "0"? If so, you could check for those in a different way. ... View more

@sushviper1 In your expression you are trying to compare a character value to a numeric one. The app cannot evaluate whether a character string is "greater than" zero.   It would be helpful if you could provide an example value from your Loan account number column. ... View more

If the account number only contains number characters, you can use the TreatAs() operator to cast the values to numeric. If you have values like "12344A", then expression syntax cannot evaluate whether that is greater than zero. ... View more

@sushviper1 wrote: Hi @Sam_SAS ,   I tried above solution and created calculated filter along with advance filter , my input textbox having alphanumeric value like ABC123 . so i kept input textbox as Character . In advance filter i used below code    IF (GetWord('Loan Account No'n)>0)     RETURN (( UpperCase('Loan Account No'n) Contains UpperCase('Parm1'n) ) OR ( UpperCase('Loan Account No'n) Contains LowerCase('Parm2'n) )) ELSE (1=1)   this showing me an error as Expected : Numeric constant ,numeric, date or datetime . i dont know how to resolve this issue . Hello, I think the main issue is with your IF condition -- GetWord() will return a string but you are comparing it to a number. Did you mean to use GetLength()? Your RETURN clause has UpperCase(), but I think that should be UpCase(). Unless the name was different before VA 7.5. Let us know if that helps! Sam ... View more

Hello Surya,   You want to automatically export the data from a report when you click the report link?   When you create a report link, there is an option to set the report prompts in the target report, which is one way to transfer the current view state from one report to another.  But I don't know if there is a way to automatically export in the way you are saying.   Sam ... View more

Here is some more detail about the solution that @acordes suggested:   As far as I can tell, this workaround will only work well if there is one row for each date in the data query. The user experience becomes very confusing if, for example, the row for 27JAN2025 contains the aggregation of 10 values in the underlying data query. (Because the calculation only compares the first and last row in the query, which would not match what is displayed in the list table in this case.)   You will need to create a filter action from the first list table to the one that displays the difference row.   If the user selects multiple rows, it will calculate the difference between the first and last row only. (As the user would probably expect) ... View more

Clever, I couldn't think of a good way to retrieve two selections from a list table. @acordes , could you show your expression for diff_a? You would need to create calculated items for every numeric column in the list table, I think. ... View more

Hello,   I'm not sure I understand  the second question. When you export the data from a list table object in a report, the resulting spreadsheet or CSV file will contain only the data that is present in the list table object. That is, any filter prompts that affect the list table will also affect the exported data. If I have a year prompt in my report and I select 2024, then only data from 2024 is exported.   What I'm not sure I understand is the part of your question about multiple reports. A report prompt will affect all of the pages and objects in that report, but it does not affect other reports. (Except if you create a report link with the Set prompt bar values of target report option, but that only applies when you open the other report through the report link.)   I'm not sure if that answers your question.   Sam ... View more

Thank you, that is very helpful! Selecting two rows in a list table and calculating the differences for all the columns, I don't think we can currently do that in VA. This would be a good feature to request at the Product Feature Suggestions board here: https://communities.sas.com/t5/SAS-Product-Suggestions/idb-p/product-suggestions The product manager for VA reviews the suggestions. Thanks, Sam ... View more

Hello, can you show us a sample of what your data looks like? That would really help us to assist you.   Thanks, Sam ... View more

Hello,   I think there are a lot of options to achieve what you want.   With a Text object, you could enter your commentary directly in the report. Depending on the version of VA you have, you might be able to insert dynamic text (that is, data-driven values) into the commentary in the Text object. You can make the contents of a Text object into a "Report summary" (see Creating a Report Summary ) but I'm not sure whether this is what you are thinking of.   Also in a Text object you can insert a link to an external web page or a file such as the XLS/CSV file you mentioned.   In a Web Content object, you could display the contents of a web page inline in the report.   Does this help? Sam ... View more

There can be literally hundreds of columns, so it might be an implementation challenge to have width options at the column level. But there's no harm entering a suggestion for it : ) ... View more

Hello,   The questions you are asking make me wonder if your crosstab would work better with the axes reversed. Something to try, perhaps.   I don't think there are options to do what you are asking for. By "blank space" do you mean the empty rows like you see here?   Would you want the row height to expand to fully fill the vertical space?   Being able to specify the column widths as a percentage, etc on the Options pane seems useful, although in practice this could be problematic when people view the report on a smaller device, at a lower screen resolution, or at a higher magnification.   You can submit product feature suggestions here: https://communities.sas.com/t5/SAS-Product-Suggestions/idb-p/product-suggestions The product manager for VA reviews the suggestions.   Sam ... View more