Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I 've date-wise values for almost 10 years of data. I need to provide line-chart in QlikView of the said data. However, I need to provide Quarter-Year on X-Axis, while showing all values within that Quarter-Year on Line-Chart. The example of chart can be found at http://fivethirtyeight.blogs.nytimes.com/ Please check line-chart on right. On mouse hover, you notice that values on particular date is shown, while on x-axis only months are shown.
How can we achieve same functionality in QlikView?
Hope to hear quick response from experts
Regards
This is actually easiest to handle in the load script.
I would concatonate the two fields in your fact table.
load *, Year&'-'&Month as [Year-Month]
Sorry I see it's qtr.
same thing though...
if you don't have quarter in table then create a mapping table like this...
QTR_Map:
Mapping load * inline (
month,qtr
1,1
2,1
3,1
4,2
5,2
6,2
7,3
8,3
9,3
10,4
11,4
12,4
);
then in you fact...
Load * , year & '-' & applymap('QTR_Map',Month) as [Year-Qtr]
Hello
Thanks for your reply
However, it is not what is intended
I already have Quarter-Year Field in my model. I need to dispaly
1. Quarter-Year on X-Axis
2. Date-wise Values as plotted lines
Did you see the link I posted (http://fivethirtyeight.blogs.nytimes.com/). Please check the representation.
All I need is to add Date Dimension in Line-Chart, while date should not be shown on X-Axis, rather dates should be club in Quarter-Year and shown on X-Axis, and all the values within that Quarter are plotted. On Hover, it shows value of particualr date.
Regards
anyone could help in this regard please?
In other words, I need to show clubbed value on X-Axis.