Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
danmercer
Creator
Creator

Please explain this expression

=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.

5 Replies
jonasheisterkam
Partner
Partner

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.

maxgro
MVP
MVP

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


detail of set analysis, author is FABRICE44

Set Analysis: syntaxes, examples

engishfaque
Specialist III
Specialist III

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

Henric_Cronström

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

ashfaq_haseeb

Hi,

Check this too

Romancing with Set Analysis

Regards

ASHFAQ