topic Re: Line-Chart to display all values, while limited on X-Axis in QlikView

Line-Chart to display all values, while limited on X-Axis

Wed, 10 Oct 2012 16:40:46 GMT

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

Re: Line-Chart to display all values, while limited on X-Axis

Wed, 10 Oct 2012 16:59:31 GMT

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]

Re: Line-Chart to display all values, while limited on X-Axis

Wed, 10 Oct 2012 17:06:52 GMT

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]

Re: Line-Chart to display all values, while limited on X-Axis

Thu, 11 Oct 2012 03:55:27 GMT

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

Re: Line-Chart to display all values, while limited on X-Axis

Fri, 12 Oct 2012 03:23:18 GMT

anyone could help in this regard please?

In other words, I need to show clubbed value on X-Axis.