topic Adding a line graph with weekly dates (X axis) - Help Please! in QlikView

Adding a line graph with weekly dates (X axis) - Help Please!

Tue, 08 Jun 2010 07:17:04 GMT

I need to create a line graph which shows weekly dates (DD-MM-YY) Format on X-Axis & 'Percent %' data on Y-Axis. How do I do it?

New to QlikView so need your help on this. When I load in data from Excel sheet (*.xls), the date gets converted into the decimals. Also I need a weekly date to be shown in the graph. Could you please help me with this...

Adding a line graph with weekly dates (X axis) - Help Please!

Tue, 08 Jun 2010 11:29:11 GMT

Hi,

In the expression "X axis" use the following formula to get date format

= Date ( Date 'DD-MMM-YY') - where Date is your data

To get percentages in the Dimensions "Y axis" go to the "Number" tab in chart properties and select "Show in Percentage"

Adding a line graph with weekly dates (X axis) - Help Please!

Tue, 08 Jun 2010 13:30:37 GMT

hey, thanks much... gor the 2nd part. But still stuck up with the date thing.

For eg: 1-Jan-06 is taken as 38718. is there any way where i can take the data format as it is when i lod the data itseld in the 'Edit Script'?

Adding a line graph with weekly dates (X axis) - Help Please!

Tue, 08 Jun 2010 13:59:57 GMT

Hi,

It;s the same at the time of loading the Date variable use the following formula

date ( Date , 'DD-MMM-YY' ) as Date

And this would load the 1-Jan-06 as 1-Jan-06 and not as 38718

Adding a line graph with weekly dates (X axis) - Help Please!

Thu, 10 Jun 2010 10:25:53 GMT

Thanks! That helped... 🙂