Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have looked through qlik forums but still cannot make this work. Any help would be greatly appreciated!
Using Qlik Sense:
I have a field with number of days from promised date to delivery date. I would like to capture the frequency of days in bins from 1-9 (with greater than 9 days dumped into a single frequency).
What are the steps to do so?
data:
LOAD
round(rand() * 2000) as Value
AutoGenerate 500;
Bins: LOAD * INLINE [
Bin, Start, Stop
bin1, 0
bin2, 1
bin3, 2
bin4, 3
bin5, 4
bin6, 5
bin7, 6
bin8, 7
bin9, 8,
bin10, 9, 9999999
];
IntervalMatch(Value)
LEFT Join(Bins)
LOAD Start, Stop resident Bins;
DROP FIELDS Start, Stop;
This is working Can anyone help?
Thanks!!
hi
try this script , it should give you the desired results
the measure in the chart should be count(Value)
data:
LOAD rowno() As ID ,
round(rand() * 10) as Value
AutoGenerate 500;
Bins:
LOAD * INLINE [
Bin, Start, Stop
bin1, 0,0.9999999
bin2, 1,1.9999999
bin3, 2,2.9999999
bin4, 3,3.999999
bin5, 4,4.9999999
bin6, 5,5.999999
bin7, 6,6.999999
bin8, 7,7.999999
bin9, 8,8.9999999
bin10, 9, 9999999
];
///////////connect values
Inner Join IntervalMatch(Value)
LOAD Start, Stop resident Bins;
///////////add all records to the bins table
left join (Bins)
load * resident data;
////////////droping unrelevant table //////
DROP table data;
////////////droping unrelevant fields /////////////
drop field Start,Stop;