How to count the array from specific JSON object value?

Question

here is my javascript:

var json = '{"GetReportIdResult":[{"bulan":"4","total":"1728","type":"CHEESE1K","uang":"8796383"},{"bulan":"4","total":"572476","type":"ESL","uang":"5863408410"},{"bulan":"4","total":"33507","type":"WHP","uang":"235653242"},{"bulan":"5","total":"4761","type":"CHEESE1K","uang":"134877865"},{"bulan":"5","total":"245867","type":"UHT","uang":"1446787280"},{"bulan":"5","total":"47974","type":"WHP","uang":"631929807"},{"bulan":"6","total":"5762","type":"CHEESE1K","uang":"293393832"},{"bulan":"6","total":"236803","type":"UHT","uang":"2219506085"},{"bulan":"6","total":"24853","type":"WHP","uang":"386175022"}]}';
obj = JSON.parse(json);
var arrayobj = obj.GetReportIdResult.length;
alert (arrayobj);

I want to count how many type in the same bulan value, (e.g. there are 3 type = CHEESE1K, UHT, and ESL in bulan = 4)

how to do that?

Your json variable doesn't actually hold JSON (which would be a string), it is assigned a reference to an object, so you don't need to use JSON.parse(json). — nnnnnn
– nnnnnn, Commented Jul 4, 2012 at 4:32
@nnnnnn ops, my fault..haha I forget about that :p thank you to reminds me — blankon91
– blankon91, Commented Jul 4, 2012 at 4:42

nnnnnn · Accepted Answer · 2012-07-04 04:54:12Z

2

There's still a typo in your JSON: you've got two commas in a row between the first two "bulan":"6" objects. But assuming you fix that...

If you're asking how to count distinct types for a particular bulan value you can do something like this:

function countTypesForBulan(resultArray, bulanVal) {
   var i,
       types,
       count = 0;
   for (i=0, types = {}; i < resultArray.length; i++)
      if (resultArray[i].bulan === bulanVal && !types[resultArray[i].type]) {
         types[resultArray[i].type] = true;
         count++;
      }
   return count;
}

console.log( countTypesForBulan(obj.GetReportIdResult, "4") );  // logs 3

The above loops through the array looking for a particular bulan value, and when it finds one it checks if it has already seen the associated type - if not, it adds it to the types object and increments the counter.

Demo: http://jsfiddle.net/pAWrT/

edited Jul 4, 2012 at 4:54

answered Jul 4, 2012 at 4:43

nnnnnn

150k30 gold badges210 silver badges247 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

blankon91 Over a year ago

I try it and it shows error log that says Uncaught ReferenceError: type is not defined

nnnnnn Over a year ago

Sorry, try my updated version. I had accidentally put type where I meant resultArray[i].type. Fixed, as you can see in the demo.

Ondra Žižka · Accepted Answer · 2012-07-04 04:30:06Z

1

First of all, put the JSON into a string, else your example code wont work.

var json = '{"GetReportIdResult":[{"bulan":"4","total":"1728","type":"CHEESE1K","uang":"8796383"},{"bulan":"4","total":"572476","type":"ESL","uang":"5863408410"},{"bulan":"4","total":"33507","type":"WHP","uang":"235653242"},{"bulan":"5","total":"4761","type":"CHEESE1K","uang":"134877865"},{"bulan":"5","total":"245867","type":"UHT","uang":"1446787280"},{"bulan":"5","total":"47974","type":"WHP","uang":"631929807"},{"bulan":"6","total":"5762","type":"CHEESE1K","uang":"293393832"},,{"bulan":"6","total":"236803","type":"UHT","uang":"2219506085"},{"bulan":"6","total":"24853","type":"WHP","uang":"386175022"}]}';

Then, Iterate with for and count in a variable or a hashmap.

Since GetReportIdResult is an array, you can:

for( var i : obj.GetReportIdResult ){
    obj.GetReportIdResult[i] ... // Use at will.

answered Jul 4, 2012 at 4:30

Ondra Žižka

47.2k49 gold badges228 silver badges298 bronze badges

2 Comments

Abdullah Jibaly Over a year ago

Looks like you have some Java syntax in there :)

blankon91 Over a year ago

thank you for your answer :) but I still not understand how to use it to get what i want

Abdullah Jibaly · Accepted Answer · 2012-07-04 04:46:14Z

1

This will give you a map object which will contain the count for each bulan value. For example, map['4'].count will return 3.

var i, row, arr = obj.GetReportIdResult, map = {};
for (i = 0; i < arr.length; i++) {
    row = arr[i];
    map[row.bulan] = map[row.bulan] || {count: 0};
    if (map[row.bulan][row.type] === undefined) {
        map[row.bulan][row.type] = row.type;
        map[row.bulan]['count'] += 1;
    }
}
console.log (JSON.stringify(map));

JSFiddle here.

answered Jul 4, 2012 at 4:46

Abdullah Jibaly

55.2k45 gold badges129 silver badges201 bronze badges

1 Comment

blankon91 Over a year ago

well, the result is not like what I want, but this code is very useful for me, because after this I need to map the object :D thank you very much

Collectives™ on Stack Overflow

How to count the array from specific JSON object value?

3 Answers 3

2 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related