Create Bar chart for intervals of dates

[#1]

Hi all,

I have doubt in creating intervals of single date field. I have one date field called OrderDate. I want to create bar chart, in that chart every bar displays 15 days of sales. How can i get this? What dimension i use for this?. I want create chart like below.

Thanks in advance.

[Gysbert_Wassenaar]

See this blog post: Recipe for a Histogram

[deepakqlikview_123]

Can u plz try class or interval function

Class Function Example

Thanks,

Deepak

[deepakqlikview_123]

Class function with time interval | Qlik Community

[Kushal_Chawda]

Create the chart like below.

Dimension:

=class(OrderDate, $(vOffset))

Expression:

=Sum(Sales)

vOffset variable can be set on Button trigger.

for Button "15 Days"

Go to Button Properties->Action-> External-> Set variable

Variable = vOffset

Value =15

Like wise you can set the variable with different value for 30 days, 45 days

So when you click on 30 days button value will be set and the chart dimension will pick the offset inside class function.

[#6]

Thanks kushal.

Its working. But how can i set dimension labels like  10/13/2011 to 10/28/2011.

Any suggestion.

Thanks in advance.

[deepakqlikview_123]

try class function

[#8]

Hey Kushal,

how would I create a button?