topic Re: Represent Bucket in the Bar Chart in QlikView

Represent Bucket in the Bar Chart

victor5995 — Tue, 22 Apr 2014 13:44:58 GMT

Hi All,

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.

Thanks

Re: Represent Bucket in the Bar Chart

Roop — Tue, 22 Apr 2014 13:58:39 GMT

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.

Hope this helps

Re: Represent Bucket in the Bar Chart

victor5995 — Tue, 22 Apr 2014 14:55:26 GMT

Hi Rupert,

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.

Re: Represent Bucket in the Bar Chart

Roop — Tue, 22 Apr 2014 15:35:12 GMT

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.

You could also create another field:

if(Today(0) - DeliverDate > 0,

'Future Delivery',

if(Today(0) - DeliverDate <0,

'Late',

'Due Today'

)

) as StatusOfDelivery