Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
I only want to load data from a given year (2017).
what formula here to use?
THX!
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
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'}
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';