Dividing of time line

[#1]

Hi,

I can load data which consist of one filed like dd/mm/yyy hh:mm:ss which I can devide to month, year, day fine. I'd like to use just data from year 2014. Which formula tells QV to ignore the rest of the data. Should I define something else while defining the data or while defining the dimension in chart properties (final outcome is chart)

LOAD 

Project,

Key,

Summary,

Created,

month(Created) AS MonthCreated,

year(Created) AS YrCreated,

month(Created) & ' ' & year(Created) AS DatumCreated,

day(Created) & ' ' & month(Created) & ' ' & year(Created) AS WithoutTime,

etc

[crystles]

If you want to limit the year for the entire data set, just use a where statement at the end of your LOAD statement.

Where year='2014'

[sunny_talwar]

You need to use a where statement, may be something like this:

LOAD

Project,

Key,

Summary,

Created,

month(Created) AS MonthCreated,

year(Created) AS YrCreated,

month(Created) & ' ' & year(Created) AS DatumCreated,

day(Created) & ' ' & month(Created) & ' ' & year(Created) AS WithoutTime

FROM Source

Where Year(Created) = 2014;

[swuehl]

You can use the QV functions also in the WHERE clause

LOAD

Project,

Key,

Summary,

Created,

month(Created) AS MonthCreated,

year(Created) AS YrCreated,

month(Created) & ' ' & year(Created) AS DatumCreated,

day(Created) & ' ' & month(Created) & ' ' & year(Created) AS WithoutTime,

...

FROM ....

WHERE Year(Created) = 2014;

[sebastianlettner]

Hi,

if you just need the data for 2014 in the app you can use WHERE at you load statement.

LOAD

Project,

Key,

Summary,

Created,

month(Created) AS MonthCreated,

year(Created) AS YrCreated,

month(Created) & ' ' & year(Created) AS DatumCreated,

day(Created) & ' ' & month(Created) & ' ' & year(Created) AS WithoutTime

Resident data

WHERE year(Created) = 2014;

If you need the data in the app but not in the chart use set analysis for the expressions.

E.g. Count({<YrCreated={"2014"}>} Project)

Regards

Sebastian Lettner

[MarcoWedel]

another one:

LOAD *

Where YrCreated = 2014;

LOAD

Project,

Key,

Summary,

Created,

month(Created) AS MonthCreated,

year(Created) AS YrCreated,

month(Created) & ' ' & year(Created) AS DatumCreated,

day(Created) & ' ' & month(Created) & ' ' & year(Created) AS WithoutTime,

etc

hope this helps

regards

Marco