As I am new to qlikview try to figure out how to use bucket in the bar chart.
Here I have field Order Due Date available to me. So Orders that are having due date< Today are Overdue, due date=Today are today, due date>today than divide them as Today+1, Today+2,...thorough Today+6
I have to represent number of Customer Orders that are Due in Bar chart in a way of how many orders are Overdue, Due Today, Due Today+1, Due Today+2,..thorught Today +6 if time slider is filtering the data less than week.
If time slider is filtering less than month then Overdue, Due Today, Due Week 1 , Due Week 2, Due Week 3
If time slider is filtering month or more than a month then Overdue, Due Today, Due Week 1, Due Month 1 like that.
If some one can help me regarding this, I really appriciate the help.
I would suggest taking your date field and subtracting today(0) - The zero being from when the script was run. This will give you a value that is either Zero for today, positive for orders due in future and negative for those orders past the due date.
Thanks for your quick response and the logic you gave me that I used but here I am trying to represent them in a chart in such a way that it is associated with the selection of slider as I mentioned above.
Link the slider on the field created above and then you will be able to select whatever values you want on the slider. By using multiple values, you can then select ranges of days.
