Using Set Analysis as a variable....

Anonymous — Fri, 07 Apr 2017 11:33:32 GMT

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

Re: Using Set Analysis as a variable....

sunny_talwar — Fri, 07 Apr 2017 11:36:41 GMT

Try this

Count(DISTINCT $(vTest)>} CaseID)

Re: Using Set Analysis as a variable....

sunny_talwar — Fri, 07 Apr 2017 11:37:26 GMT

or this

Count(DISTINCT $(=$(vTest) & '>}') CaseID)

Re: Using Set Analysis as a variable....

Anonymous — Mon, 10 Apr 2017 10:31:07 GMT

Did it work? Can you enlighten us please?

Re: Using Set Analysis as a variable....

Anonymous — Mon, 10 Apr 2017 10:32:45 GMT

This worked really well - many thanks for your help.

My apologies for the time in responding - I was away for the weekend.

Cheers

Chris

topic Re: Using Set Analysis as a variable.... in App Development

Using Set Analysis as a variable....

Re: Using Set Analysis as a variable....

Re: Using Set Analysis as a variable....

Re: Using Set Analysis as a variable....

Re: Using Set Analysis as a variable....