topic Re: Creating multiple charts based on single date dimension in QlikView

Creating multiple charts based on single date dimension

Sat, 07 May 2016 05:25:40 GMT

Hi,

Please help me for this scenario. I have a date dimension column where I have dates for 1 year. I have another column for sales at the day level. I want to create 12 chart which means 1 chart per month in the year to compare the trend of sales. This will help me to know which week of the month or date range of the month or days of the month the sales increases or dips.

Thanks,

Mani.

Re: Creating multiple charts based on single date dimension

HirisH_V7 — Sat, 07 May 2016 11:42:36 GMT

Hi,

Check this,

From this Sample Data,

Data:

LOAD * INLINE [

Date, Sales

09/01/2016, 334

09/01/2016, 4

09/02/2016, 4

09/02/2016, 566

09/02/2016, 78

01/03/2016, 89

01/03/2016, 887

01/03/2016, 12

09/02/2016, 22

09/02/2016, 334

09/02/2016, 4

01/03/2016, 4

01/03/2016, 566

09/02/2016, 78

09/02/2016, 89

09/02/2016, 887

09/02/2016, 12

09/02/2016, 22

09/02/2016, 334

09/02/2016, 4

01/03/2016, 4

01/03/2016, 566

29/02/2016, 78

29/02/2016, 89

29/02/2016, 887

];

In the Chart by creating a Drill Down group as,

MonthName(Date)
&
Week(Date)

There by using this as a Chart dimension and by using sales as expression.When you select Month , you can drill down to its weeks.

Hope this helps,

PFA,

Hirish

Re: Creating multiple charts based on single date dimension

rrsrini2907 — Sat, 07 May 2016 14:48:16 GMT

Hi,

I believe you are looking for Trellis chart.

Attached the below image.

Regards,

Srini.

Re: Creating multiple charts based on single date dimension

Kushal_Chawda — Sat, 07 May 2016 15:14:26 GMT

why you want to create the 12 charts. One chart is enough to do the analysis that you want.

Just create the Calendar which will have Year, Month, Week, Quarters. You can display all these fields in listbox and just do the selections

Re: Creating multiple charts based on single date dimension

Sat, 07 May 2016 17:00:41 GMT

Your chart shows one bar per month. What I was looking for is that each chart should display one chart for month at the day level data and for 12 charts for 12 months. The reason is that I want to visually know the ups and downs for all 12 months.

Thanks.

Re: Creating multiple charts based on single date dimension

Sat, 07 May 2016 17:11:22 GMT

Hi, I'm aware of trellis chart. I tried that also. For each of the month the bars are getting displayed for that particular month and for other months it was blank. So it display 12 months of data horizontally but display bars for only that particular month data. I do not want to see the data for other months without bars.

Thanks.

Re: Creating multiple charts based on single date dimension

Sat, 07 May 2016 17:17:50 GMT

Hi, This is a good one. But I want to see the trend at the day level to compare for each month so that I can understand pattern in the ups and downs and narrow down the date or week or weeks or range of days in the month.

Thanks.

Re: Creating multiple charts based on single date dimension

HirisH_V7 — Sat, 07 May 2016 17:21:23 GMT

Hi,

Can you please make your requirement on excel or Make a sample of it.

With your Requirement as a Plot Diagram.

-Hirish

Re: Creating multiple charts based on single date dimension

MarcoWedel — Sat, 07 May 2016 23:53:31 GMT

Hi,

one solution could be to create two calculated dimensions Day and Month:

If possible,you should create Day and Month fields in the script already.

Re: Creating multiple charts based on single date dimension

Sun, 08 May 2016 00:36:44 GMT

Is this something you are looking for?

It has divided into months and you can compare dates in each month.

Re: Creating multiple charts based on single date dimension

Thu, 12 May 2016 12:58:32 GMT

Hi, This looks good as an alternate solution. But what I'm looking for is the one which Saikrishna Madhireddy has created using trellies. But I do not want to see the blank dates from other months.

Re: Creating multiple charts based on single date dimension

Thu, 12 May 2016 13:00:22 GMT

Saikrishna, I have already tried this. But I do not want to see the blank dates from other months. For example, for Jan chart, it currently display dates from other months in the x axis with no bars which I do not want to see. Please let me know if there is a way.