Year

[#1]

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.

[MK_QSL]

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

[#3]

I don't think it will work that way. You will have to add year and month fields in your load script.

Thanks

[don_qlikview]

Load * Inline [

Year, Month

2014, Jan

2014, Feb

.....

....

.....

2014, Dec

];

Will this work?

[#5]

Sorry, have added the Inline table as advised by you, but still no Year & Month is not shown in the chart...

[anbu1984]

You have to associate inline data with your source data. Create columns Year and Month from your source data

[don_qlikview]

Try this

Concatenate(Your Table Name)

Load * Inline [

];

[ecolomer]

And which year and month need you?  from Today?

If yes .... then

year = year(Today())

month = Month(Today())