write in Set analysis

[#1]

sum(if(vRFRB='C' and MeetingDateRFRB>=DateCurrPeriodStart,TotalLoanAccountNumber,

if(vRFRB='A' and MeetingDateRFRB>=DateCurrPeriodStart,TotalToBeCollected)))

Help Is Appreciated

Thanks

Charleo

[Anonymous]

Hi Charlie,

Please use the below link.  It has helped me a great amount.

http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=

Sum({$<vRFRB={'C'},MeetingDateRFRB={">=$(=DateCurrPeriodStart)"}>}TotalLoanAccountNumber)

Sum({$<vRFRB={'A'},MeetingDateRFRB={">=$(=DateCurrPeriodStart)"}>}TotalToBeCollected)

[#3]

how did you wrote the xpression by using the above link / site..

[Anonymous]

It asks you what you want to calculate.  So enter the field you which to calculate and the method you wish to use i.e Sum, max, min, etc.  Then click on "Add a set to modify the set defined above".

Then choose what you wish to do example "Modify the set by explicitly defining values"

Then add your field and your condition. once you save the formula shows at the bottom of the page.

[#5]

hey

confused it is , can you please explain it clear , where u gave what ......and it is only one expression .

please be clear , sorry troubling you dude

[Anonymous · Accepted solution]

Step 1:

I Selected the Sum of TotalAccountNumber

Step 2:

Click on Modify the Set:

So if you are making comparisons, use "Modify the set by using expressions", but when looking at a specific value use "Modify the Set explicitly by defining Values"

Because you wanted to sum everything based on vRFVB being equal to "C" I entered it as below:

Then you can add another modifcation by repeating step 2. This time you wanted to sum only based on values that are greater than or equal to another field.  Thus i filled the values as below.

Finally i just copied the formula from the bottom of the page.  I hope this helps !

Play around with the different modifications until you get the result you need.  Goodluck !

[#7]

DUDE UR AWESOME....

Thanks

charleo