Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhas277
Creator
Creator

indirect set analysis?

Hi folks,

i am getting the correct  result for this expression

sum({<year={"*"}-{"2009"}>}sales)

and

i am getting the same result for this expression also .

sum({<year=E({1<year={"*09*"}>})>}sales)

then why should i use indirect set analysis here ? when should i go for this ?

what is the use of indirect set analysis ?

1 Reply
swuehl
MVP
MVP

You posted a single example (and I am not sure that both return the same results under all conditions, what about making selections in year field?) and there might be several ways to achieve the same, but there are lot of other queries where it's easier or only possible to achieve what you want by using implicite field value definitions ( p() and e() function).

For example, the Help gives a simple example like

=sum( {$<Customer = P({1<Product={‘Shoe’}>} Customer)>} Sales )

returns the sales for current selection, but only those customers that ever have bought the product ‘Shoe’. The element function P( ) here returns a list of possible customers; those that are implied by the selection ‘Shoe’ in the field Product.


I find it a compact and quite easy to understand way of defining your query (having the QV three-color-logic in mind).

And how would you express it in a different way, as easy to read and write?