topic Re: Year in QlikView

Year

Thu, 11 Sep 2014 15:20:34 GMT

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 — Thu, 11 Sep 2014 15:23:25 GMT

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

Thu, 11 Sep 2014 15:24:54 GMT

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 — Thu, 11 Sep 2014 15:27:13 GMT

Load * Inline [

Year, Month

2014, Jan

2014, Feb

.....

....

.....

2014, Dec

];

Will this work?

Thu, 11 Sep 2014 16:40:35 GMT

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

anbu1984 — Thu, 11 Sep 2014 16:56:50 GMT

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

don_qlikview — Thu, 11 Sep 2014 17:05:32 GMT

Try this

Concatenate(Your Table Name)

Load * Inline [

];

ecolomer — Thu, 11 Sep 2014 17:08:03 GMT

And which year and month need you? from Today?

If yes .... then

year = year(Today())

month = Month(Today())