Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Creating multiple charts based on single date dimension

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.

11 Replies
HirisH_V7
Honored Contributor

Re: Creating multiple charts based on single date dimension

Hi,

Check this,

From this Sample Data,

Data:

LOAD * INLINE [

    Date, Sales

    09/01/2016, 334

    09/01/2016, 4

    09/01/2016, 4

    09/02/2016, 4

    09/02/2016, 566

    09/02/2016, 78

    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, 4

    01/03/2016, 566

    09/02/2016, 78

    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

    09/02/2016, 4

    01/03/2016, 4

    01/03/2016, 566

    29/02/2016, 78

    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.

Dates-Yearly-Monthly-Weekly Chart- Sales 215946.PNG

Hope this helps,

PFA,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Highlighted
rrsrini2907
Contributor

Re: Creating multiple charts based on single date dimension

Hi,

I believe you are looking for Trellis chart.

Attached the below image.

Regards,

Srini.Trellis Chart.png

Re: Creating multiple charts based on single date dimension

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

Not applicable

Re: Creating multiple charts based on single date dimension

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.

Not applicable

Re: Creating multiple charts based on single date dimension

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.

Not applicable

Re: Creating multiple charts based on single date dimension

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.

HirisH_V7
Honored Contributor

Re: Creating multiple charts based on single date dimension

Hi,

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

&

With your Requirement as a Plot Diagram.

-Hirish

HirisH
“Aspire to Inspire before we Expire!”

Re: Creating multiple charts based on single date dimension

Hi,

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

QlikCommunity_Thread_215946_Pic1.JPG

QlikCommunity_Thread_215946_Pic2.JPG

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

See also: The Master Calendar

hope this helps

regards

Marco

Not applicable

Re: Creating multiple charts based on single date dimension

trellis.PNG

Is this something you are looking for?

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