topic Re: Please explain this expression in QlikView

Please explain this expression

Anonymous — Sun, 18 Jan 2015 15:17:04 GMT

=SUM({$<[Opportunity Type]={'New Customer'}>} [MRR])

The above expression is something that someone else did several months ago at my request while I looked over their shoulder. I had to step away from the development of that app and am getting back to it now. I want to add another wrinkle, but I need to know what the "$" "{}" and "<>" are doing in this case before I can really move on.

Is there an advantage of doing the formula this way instead of a simple sumif? I realize that may be hard to answer without seeing the full thing.

I want to add in [Won_Flag] = 1. Long story short, we're adding up the new customers who have signed deals.

Re: Please explain this expression

jonasheisterkam — Sun, 18 Jan 2015 15:23:48 GMT

Takes the sum of MRR, it modifies the selection. $ is the actual default selection state and in Opportunity Type the selection is modified to 'New Customer'.

You find all the information in the help under set analysis.

Re: Please explain this expression

maxgro — Sun, 18 Jan 2015 16:20:51 GMT

=SUM({$<[Opportunity Type]={'New Customer'},Won_Flag={1}>} [MRR])

detail of set analysis, author is FABRICE44

Set Analysis: syntaxes, examples

Re: Please explain this expression

engishfaque — Sun, 18 Jan 2015 18:14:43 GMT

Dear Dan,

Her is the translation for you set analysis.

Set Analysis:

=SUM({$<[Opportunity Type]={'New Customer'}>} [MRR])

Translation:

Returns the [MRR] for the current selection where [Opportunity Type] is equal to 'New Customer'

Kind regards,

Ishfaque Ahmed

Re: Please explain this expression

hic — Sun, 18 Jan 2015 18:37:08 GMT

If you just want to add a condition on Won_Flag, I suggest you do what Massimo suggests.

Further, you ask if there is an advantage of using Set Analysis instead of a simple sumif. The answer is yes - at least for large data amounts. Set Analysis usually has better performance.

See more on Performance of Conditional Aggregations

HIC

Re: Please explain this expression

ashfaq_haseeb — Mon, 19 Jan 2015 05:35:30 GMT

Hi,

Check this too

Romancing with Set Analysis

Regards

ASHFAQ