topic Re: Creating week over week chart in QlikView

Creating week over week chart

Mon, 12 May 2014 19:56:41 GMT

Hi there. New to qlikview and wanted to see if anyone could help figure out how to create a rolling 7 day week over week chart.

Re: Creating week over week chart

Mon, 12 May 2014 21:01:13 GMT

Do you have idea how this chart should look like?

What values do you like to analyse?

What are your input data?

regards

Darek

Re: Creating week over week chart

Tue, 13 May 2014 17:50:48 GMT

Thanks for your reply. The look is actually two bar charts…one showing the target and the other showing the actual. There are several metrics that I am graphing and have done a rolling 30 day chart— I want the same look and feel but as a rolling 7 day. It should look like this:

Re: Creating week over week chart

Tue, 13 May 2014 19:40:08 GMT

How do you know your chart start and end dates?

Does user selecting it?

I think that you need set analysis to manage dates. But i undestand, that with your first day on the chart you would like to see value fromn that day and value existing 7 days earlier. So, this may be done if you will have additional calendar - dimension. You may create in this dimension 2 rows for each date. The table may have fields like this:

Date_WD, RefType_WD, Date

2014-01-08, 'Curr', 2014-01-08

2014-01-08, 'Prev', 2014-01-01

2014-01-09, 'Curr', 2014-01-09

2014-01-09, 'Prev', 2014-01-02

.........

So, in your chart you will use Date_WD as Dimension.

Date field will be reference to field in your normal calendar.

RefType_WD will be differentaiator, which you will use in your set analysis.

Let me know if this concept meets your requirments and if you need more help.

Regards

Darek