topic Help to create the bucket in QlikView https://community.qlik.com/t5/QlikView/Help-to-create-the-bucket/m-p/565342#M210945 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt; background: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">Hi,</SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;"> </SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">I have a field bucket where the value is starting from 11 to 36+, but I need, where in my bucket field if there is data available or not but it should to start with 1 and till 36+, If in bucket 1 there is no data as corresponding to the same, It will be null and if there is data for the same bucket 11, it will be present there.</SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;"> </SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">For more ref. please find the attached xls. I have the data like sheet1 but output should be like sheet2.</SPAN></P></BODY></HTML> Thu, 27 Mar 2014 05:08:12 GMT sona_sa 2014-03-27T05:08:12Z Help to create the bucket https://community.qlik.com/t5/QlikView/Help-to-create-the-bucket/m-p/565342#M210945 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt; background: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">Hi,</SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;"> </SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">I have a field bucket where the value is starting from 11 to 36+, but I need, where in my bucket field if there is data available or not but it should to start with 1 and till 36+, If in bucket 1 there is no data as corresponding to the same, It will be null and if there is data for the same bucket 11, it will be present there.</SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;"> </SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">For more ref. please find the attached xls. I have the data like sheet1 but output should be like sheet2.</SPAN></P></BODY></HTML> Thu, 27 Mar 2014 05:08:12 GMT https://community.qlik.com/t5/QlikView/Help-to-create-the-bucket/m-p/565342#M210945 sona_sa 2014-03-27T05:08:12Z