6 Replies Latest reply: Jun 7, 2017 1:20 AM by Charlie Leo

write in Set analysis

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

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

Help Is Appreciated

Thanks

Charleo

• Re: write in Set analysis

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)

• Re: write in Set analysis

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

• Re: write in Set analysis

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.

• Re: write in Set analysis

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

• Re: write in Set analysis

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 !

• Re: write in Set analysis

DUDE UR AWESOME....

Thanks

charleo