
Re: Distribution Question
Sunny Talwar Jun 14, 2016 5:29 AM (in response to barry WIlmer)Would you be able to share the excel file here and may be let us know which of the columns need to be calculated in Qlik Sense?


Re: Distribution Question
Sunny Talwar Jun 14, 2016 7:22 AM (in response to barry WIlmer)Can you post the data in Excel format? Images require me to manually enter all the data into QlikView. If you need directions on how to upload files to community, check this out > Uploading a Sample

Re: Distribution Question
barry WIlmer Jun 14, 2016 7:28 AM (in response to Sunny Talwar )Sorry here is a sample of my data
thanks

sample data.xlsx 12.9 K

Re: Distribution Question
Sunny Talwar Jun 14, 2016 1:20 PM (in response to barry WIlmer)May be like this. Script:
Table:
LOAD [Working Price],
If([Working Price] <= 100, Dual('<=100', 1),
If([Working Price] <= 500, Dual('<=500', 2),
If([Working Price] <= 1000, Dual('<=1000', 3),
If([Working Price] <= 3000, Dual('<=3000', 4),
If([Working Price] <= 5000, Dual('<=5000', 5),
If([Working Price] <= 10000, Dual('<=10000', 6),
If([Working Price] <= 15000, Dual('<=15000', 7),
If([Working Price] <= 20000, Dual('<=20000', 8),
If([Working Price] <= 25000, Dual('<=25000', 9),
If([Working Price] <= 50000, Dual('<=50000', 10),
If([Working Price] <= 75000, Dual('<=75000', 11),
If([Working Price] <= 100000, Dual('<=100000', 12),
If([Working Price] <= 250000, Dual('<=250000', 13),
If([Working Price] <= 500000, Dual('<=500000', 14),
If([Working Price] <= 1000000, Dual('<=1000000', 15),
If([Working Price] <= 2000000, Dual('<=2000000', 16),
If([Working Price] <= 5000000, Dual('<=5000000', 17),
If([Working Price] <= 10000000, Dual('<=10000000', 18),
If([Working Price] <= 25000000, Dual('<=25000000', 19)))))))))))))))))))) as Bin
FROM
[sample data.xlsx]
(ooxml, embedded labels, table is Sheet1);
Line chart
Dimension
Bin
Expressions
1) =RangeSum(Above(Sum([Working Price]), 0, RowNo()))/Sum(TOTAL [Working Price])
2) =RangeSum(Above(Count([Working Price]), 0, RowNo()))/Count(TOTAL [Working Price])
I calculated Bin in the script, but can be done dynamically on the front end as well.

Community_220724.qvw 155.5 K

Re: Distribution Question
barry WIlmer Jun 15, 2016 5:37 AM (in response to Sunny Talwar )Sunny
Thanks for your help it works brilliantly



