Hello
I have a attached a QVW which is a much more more streamlined version of what I have in my "Real" document, but the concept is the same
I have a document which contains 3 tables. Main, Eye and Total.
Both Main and Eye have a date field, which I use set anlaysis in the expression to ascertain the Maximum Month, Maximum Quarter and YTD
In the Total table I want to be able to write a more simplified expression but my problem lies with the fact that the Main and Eye tables are looking at different dates, so concatenating the data together in the script is proving difficult and takes 11 seconds to click between the 3 tables (In my real version)
Could someone kindly take a look at the script and the expressions, and help me write it so I can streamline the amount of coding in the expression
Any help or advice would be greatly appreciated
Thanks
Helen
