Discussion Board for collaboration on QlikView Scripting.
Hi, using below data,how to plot a multiple time dimension on same axis and create column chart ?
Please refer to attahcment
Message was edited by: Kaustubh Bagal
Go to Solution.
try aggregating the data in the script
Month as Time,
sum(Sales) as Sales,
1 as SortPrio
Resident Data Group by Month;
Week as Time,
2 as SortPrio
Resident Data Group by Week;
InvoiceDate as Time,
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.
there is no attachment?
Hi Marco, now attachment added. Please check.