Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Show multiple Time dimension on same axis

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

Data:

InvoiceDateSalesWeekMonth
09/09/201410037Sep
10/09/201420037Sep
11/09/201440037Sep
12/09/201480037Sep
13/09/201490037Sep
14/09/2014120038Sep
15/09/2014140038Sep
16/09/2014250038Sep

Desire Output:

Please refer to attahcment

Message was edited by: Kaustubh Bagal

1 Solution

Accepted Solutions
s_kunte23
Contributor III

Re: Show multiple Time dimension on same axis

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

4 Replies

Re: Show multiple Time dimension on same axis

there is no attachment?

Not applicable

Re: Show multiple Time dimension on same axis

Hi Marco, now attachment added. Please check.

s_kunte23
Contributor III

Re: Show multiple Time dimension on same axis

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

Not applicable

Re: Show multiple Time dimension on same axis

Thanks Stefan 

Community Browser