topic Re: Create Bar chart for intervals of dates in QlikView

Create Bar chart for intervals of dates

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Create Bar chart for intervals of dates

Gysbert_Wassenaar — Thu, 14 Apr 2016 07:15:28 GMT

See this blog post: Recipe for a Histogram

Re: Create Bar chart for intervals of dates

deepakqlikview_123 — Thu, 14 Apr 2016 07:15:54 GMT

Can u plz try class or interval function

Class Function Example

Thanks,

Deepak

Re: Create Bar chart for intervals of dates

deepakqlikview_123 — Thu, 14 Apr 2016 07:18:55 GMT

Class function with time interval | Qlik Community

Re: Create Bar chart for intervals of dates

Kushal_Chawda — Thu, 14 Apr 2016 07:29:20 GMT

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.

Re: Create Bar chart for intervals of dates

Thu, 14 Apr 2016 11:01:58 GMT

Thanks kushal.

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

Any suggestion.

Thanks in advance.

Re: Create Bar chart for intervals of dates

deepakqlikview_123 — Thu, 14 Apr 2016 13:05:42 GMT

try class function

Re: Create Bar chart for intervals of dates

Tue, 30 Aug 2016 14:56:19 GMT

Hey Kushal,

how would I create a button?