exclude data

[Anonymous]

hello,

I only want to load data from a given year (2017).

what formula here to use?

THX!

[alexandros17]

Suppose you have a field with a data (eg.: dt) in a table myTable

you have to write something like this:

Select * from myTable where year(dt) >= 2017;

let me know

[Anil_Babu_Samineni]

May be this?

Select Year from Table where Year = 2017; // Year <> 2017 for exclude the value(as per your title)

Load Year from Table where Year = 2017; // Year <> 2017 for exclude the value(as per your title)

And, In front end

Sum({<Year = {'2017'}>}Measure) // Year -= {'2017'}

[its_anandrjs]

In Qlikview try this way

Load

*

From Table

Where Year = 2017;

Or

Load

*

From Table Where  Year = Match(Year,2017);

Or

Load

*

From Table Where  Match(Year,2017)=1;

Or

Load * From Table Year Like '2017';