
Re: write in Set analysis
Ruan Greeff Jun 6, 2017 8:28 AM (in response to Charlie Leo)Hi Charlie,
Please use the below link. It has helped me a great amount.
http://tools.qlikblog.at/SetAnalysisWizard/QlikViewSetAnalysis_Wizard_and_Generator.aspx?sa=
Sum({$<vRFRB={'C'},MeetingDateRFRB={">=$(=DateCurrPeriodStart)"}>}TotalLoanAccountNumber)
Sum({$<vRFRB={'A'},MeetingDateRFRB={">=$(=DateCurrPeriodStart)"}>}TotalToBeCollected)

Re: write in Set analysis
Charlie Leo Jun 6, 2017 8:47 AM (in response to Ruan Greeff)how did you wrote the xpression by using the above link / site..

Re: write in Set analysis
Ruan Greeff Jun 6, 2017 8:51 AM (in response to Charlie Leo)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
Charlie Leo Jun 6, 2017 9:04 AM (in response to Ruan Greeff)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
Ruan Greeff Jun 6, 2017 9:22 AM (in response to Charlie Leo)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
Charlie Leo Jun 7, 2017 1:20 AM (in response to Ruan Greeff)DUDE UR AWESOME....
Thanks
charleo




