Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dividing of time line

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

5 Replies
crystles
Partner
Partner

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

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