topic exclude data in QlikView

exclude data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hello,

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

what formula here to use?

THX!

alexandros17 — Wed, 25 Oct 2017 15:30:25 GMT

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 — Wed, 25 Oct 2017 15:36:00 GMT

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 — Wed, 25 Oct 2017 15:41:24 GMT

In Qlikview try this way

Load

From Table

Where Year = 2017;

Load

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

Load

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

Load * From Table Year Like '2017';