Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Help to create the bucket

Hi,

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.

For more ref. please find the attached xls. I have the data like sheet1 but output should be like sheet2.

0 Replies