topic Re: Show multiple Time dimension on same axis in QlikView

Show multiple Time dimension on same axis

Tue, 09 Sep 2014 17:14:10 GMT

Hi, using below data,how to plot a multiple time dimension on same axis and create column chart ?

Data:

Desire Output:

Please refer to attahcment

Message was edited by: Kaustubh Bagal

MarcoWedel — Tue, 09 Sep 2014 17:54:06 GMT

there is no attachment?

Wed, 10 Sep 2014 04:24:01 GMT

Hi Marco, now attachment added. Please check.

Anonymous — Wed, 10 Sep 2014 21:36:09 GMT

hi,

try aggregating the data in the script

TimeTable:

load

Month as Time,

sum(Sales) as Sales,

1 as SortPrio

Resident Data Group by Month;

concatenate (TimeTable)

load

Week as Time,

sum(Sales) as Sales,

2 as SortPrio

Resident Data Group by Week;

concatenate (TimeTable)

load

InvoiceDate as Time,

sum(Sales) as Sales,

3 as SortPrio

Resident Data Group by InvoiceDate;

you can skip the last sum(Sales) and group by InvoieDate if you only have one data entry for a specific day.

Use Time as Dimension in your chart.

Best

Stefan

Thu, 11 Sep 2014 06:09:52 GMT

Thanks Stefan