topic Re: Order by Year in QlikView

Order by Year

Wed, 14 May 2014 14:37:35 GMT

Hi! I've got a table where a column contain a list of date for example "20/02/1964". I want to obtain a new column where i can see only the year for each date. What kind of string i have to type to obtain this result??

Re: Order by Year

Anonymous — Wed, 14 May 2014 14:40:44 GMT

use date functions like

year(yourdate)

maybe you have to convert your date if Qlikview doesnot recognize it as data, the use date(date#(yourdate,'DD/MM/YYYY')

Re: Order by Year

Anonymous — Wed, 14 May 2014 14:42:56 GMT

Hi,

year function will help you..

example

table a:

load

name,

age,

date,

year(date) as year

from

datasource order by year(date) ;

i hope this will help u..

Re: Order by Year

maleksafa — Wed, 14 May 2014 14:46:46 GMT

you can add it in the script when loading the data using the Year function, year(data field) or use a calculated dimension in the chart and add the function there Year(data field), however it is not preferred to use calculated dimension instead add it in the load script.

Re: Order by Year

martinpedersen — Wed, 14 May 2014 14:47:52 GMT

Hi Gabrielle,

Are you working in the Load script og in a chart?

In Load Script:

If in the Load-script, something like this will do the trick:

Data:

Load Date, Year(Date) as Year, * From Data.Qvd (qvd);

In Charts:

If your are working in a chart you can add a calculated dimension with the expression Year(Date) :