Show frequency in list-box(custom made by Expression) ?

[ganeshreddy]

Hi All,

Ia m finding difficulty wile showing the frequency of of bucket, list box illustrated in below picture. PFA attached QVW as well

[morganaaron]

Are you not just using the wrong field? If you want the frequency use Count(distinct name) and it should work..

[ashwanin]

Do it in script level, then you can find the frequency.

[ashwanin · Accepted solution]

add the below script

inline:

LOAD * INLINE [

    name, age, 

    sri, 25

    ram, 10

    ganesh, 20

    vamsi, 12

    venkat, 18

    valli, 15

    satish, 30

    rajesh, 28

    dharam, 27

    dhana, 19

    sunny, 20

    yashu, 6

];

load *,

Dual(Replace(Class(age,10),'<= x <','to'), Num(Class(age,10))) as Bucket

resident inline;

QVW Attached

[vvvvvvizard]

Good day , attached is the qvw app solved

[ganeshreddy]

Hi Aron ,

FYI i just want to archive bucket frequency. Problem solved, please see marked correct answer.

Cheers,

Ganesh

[morganaaron]

No worries - may be worth stating that next time as that's a different problem to the one you posted!

Cheers

[ganeshreddy]

Thank you Ashwin, i got my desired result. but my doubt is still unclear. why show frequency is grayed out while using list box as expression. 

Cheers,

Ganesh

[ashwanin]

Hi Ganesh,

This might be due to Calculated values. When get values through expression in List box, it always greyed the frequency.

Also You can also use this formula in script

class(age,10,'age',10) as Bucket