Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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"
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"
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'?
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
Thanks! That helped... 🙂