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

[#1]

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...

[#2 · Accepted solution]

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"

[#3]

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'?

[#4]

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

[#5]

Thanks! That helped... 🙂