4 Replies Latest reply: Apr 10, 2017 6:32 AM by Chris Weldon RSS

    Using Set Analysis as a variable....

    Chris Weldon

      I had some really helpful feedback on here last week which has meant I am able to set a variable for a standard set analysis which is used in a lot of visualisations.

       

      The variable is called vIssuedandFinalisedQuotesInSelection and is defined as:

      {<Q_QUOTE_TrackedQuote={'Yes'},Q_QUOTE_QuoteType-={'Research'},Q_QUOTE_QuoteStatus*={'Issued','Finalised'},

      Q_QUOTE_StartDate={">=$(=date(vStartDate,'DD/MM/YYYY'))<=$(=date(vEndDate,'DD/MM/YYYY'))"}>}

       

      Then the visualisation is set up as follows:

      count(distinct $(vIssuedandFinalisedQuotesIncludedInSelection)CaseID)

       

      This all works really well....however....

       

      .....I have now worked out that not all my visualisations have exactly the same Set Analysis.  TrackedQuote, QuoteTyp eand StartDate are all common, but QuoteStatus can vary, and often there are addition selections needed...so what I really want to do is set the variable for the constant parts and then append extra bits on...

       

      So I have tried setting the variable vTest to be:

      {<Q_QUOTE_TrackedQuote={'Yes'},Q_QUOTE_QuoteType-={'Research'},Q_QUOTE_QuoteStatus*={'Issued','Finalised'},

      Q_QUOTE_StartDate={">=$(=date(vStartDate,'DD/MM/YYYY'))<=$(=date(vEndDate,'DD/MM/YYYY'))"}

       

      (so missing the last >} so I can expand it out as required)

       

      and the expression to be

      count(distinct =$(vTest&'>}')&CaseID)

       

      The expression seems to work in that it calculates something, but it does not apply any of the selections, and returns the answer value as if no selections are made.

       

      Does anyone have any ideas?  Am I mad for trying to do it this way, or is there a better way to achieve what I want, which is simplification of applying some common selections to set analysis in over 60 visualisations but allowing flexibility for local variation?

       

      Many thanks

       

      Chris