Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Ia m finding difficulty wile showing the frequency of of bucket, list box illustrated in below picture. PFA attached QVW as well
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
Are you not just using the wrong field? If you want the frequency use Count(distinct name) and it should work..
Do it in script level, then you can find the frequency.
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
Good day , attached is the qvw app solved
Hi Aron ,
FYI i just want to archive bucket frequency. Problem solved, please see marked correct answer.
Cheers,
Ganesh
No worries - may be worth stating that next time as that's a different problem to the one you posted!
Cheers
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
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