topic Re: Line chart Dimension in QlikView

Line chart Dimension

azimabadi — Thu, 05 Jul 2012 14:55:30 GMT

HI all,

I have a line chart and it's only dimension is date: 01.01.2012 , 02.01.2012, .... That means for every year i have 365 dimension vales.

Is there any way that i can show Months in Dimension Axe area insted of dates?

Best Regards

Peyman

Re: Line chart Dimension

MayilVahanan — Thu, 05 Jul 2012 15:09:45 GMT

Hi,

Did you make sure the format of date 01.01.2012 or 01/01/2012. If second one is your format means, you can change in script like this,

Load * , Month(Date) as Month from filename.fileextension;

Then Use Month as Dimension in your chart

Hope it helps

Re: Line chart Dimension

azimabadi — Thu, 05 Jul 2012 15:16:49 GMT

Hi Mayil,

Thank you so much for help. You are right, i can do this. But i don't want to aggregate different values of dimension. This means that if i have 4 values in a month, to show for value point in chart but all in the same month.

I know that my defination is not too clear, so i'm going to make a picture of what i need my chart to look like and post it soon.

Best regards

Peyman

Re: Line chart Dimension

azimabadi — Thu, 05 Jul 2012 15:26:25 GMT

Re: Line chart Dimension

azimabadi — Thu, 05 Jul 2012 15:27:11 GMT

I hope the picture help you to find out my meaning.

Best regards

Peyman

Re: Line chart Dimension

swuehl — Thu, 05 Jul 2012 15:35:28 GMT

Try using a continuous x-axis (on axis tab).

Re: Line chart Dimension

azimabadi — Thu, 05 Jul 2012 16:25:34 GMT

Hi Estefan (do i remember right?),

In this case chart shows numeric values of dates, but i need to show Month names as a calander.

Best Regards

Peyman

Re: Line chart Dimension

swuehl — Thu, 05 Jul 2012 16:32:52 GMT

This should / could be just a matter of formatting in number tab.

QV will also try to use its limited AI to change that format automatically, i.e. QV will show only years depending on range of values and available chart drawing space.

Please see attached.

Re: Line chart Dimension

azimabadi — Thu, 05 Jul 2012 16:38:06 GMT

Thank you so much,

It's really helpful and with continues set to true, i can draw vertical lines as i need.

Best Regards

Peyman