Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm not able to add Year & Month list boxes manually if it is not in the Source data file like excel or QVD . Kindly help me
to add the Year & Month list boxes manually.
What is meant by not able to add ? Can you plz clarify little more?
You mean to say you don't have Year and Month field?
if this is the case, add below two line in your script...
Year(YourDateField) as Year,
Month(YourDateField) as Month
Relaod the script and you can have now Year and Month Field...
I don't think it will work that way. You will have to add year and month fields in your load script.
Thanks
Load * Inline [
Year, Month
2014, Jan
2014, Feb
.....
....
.....
2014, Dec
];
Will this work?
Sorry, have added the Inline table as advised by you, but still no Year & Month is not shown in the chart...
You have to associate inline data with your source data. Create columns Year and Month from your source data
Try this
Concatenate(Your Table Name)
Load * Inline [
];
And which year and month need you? from Today?
If yes .... then
year = year(Today())
month = Month(Today())