Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Filter issue>>>>>Urgent

Hi all,

I have field on year.in that i have 2011,2012,2013,2014,2015.

I want only 2014 and 2015.how to do in script level.

Give me solution on ASAP

Regards,

Nagarjuna

1 Solution

Accepted Solutions
Highlighted
Master III
Master III

Re: Filter issue>>>>>Urgent

Hi,

Try this:

LOAD year

FROM

D:\Vrushali\QVDs\tab.qvd

(qvd)

Where match(Year,'2014','2015') ;


Thanks,

AS

View solution in original post

7 Replies
Highlighted
Creator III
Creator III

Re: Filter issue>>>>>Urgent

Hi,

You can add a where clause in your load script.

Load * from table

where match(year,2014,2015)

Regards,

Greeshma

Highlighted
Not applicable

Re: Filter issue>>>>>Urgent

Hi Nagarjuna,

You can achieve it by this way also,

LOAD year

FROM

D:\Vrushali\QVDs\tab.qvd

(qvd)where year>2013;

Regards,

Vrushali.

Highlighted
Not applicable

Re: Filter issue>>>>>Urgent

if(match(year,2014,2015),year);

Highlighted
Not applicable

Re: Filter issue>>>>>Urgent

if(match(year,2014,2015),year);

Highlighted
Master III
Master III

Re: Filter issue>>>>>Urgent

Hi,

Try this:

LOAD year

FROM

D:\Vrushali\QVDs\tab.qvd

(qvd)

Where match(Year,'2014','2015') ;


Thanks,

AS

View solution in original post

Highlighted
Partner
Partner

Re: Filter issue>>>>>Urgent

Thank you for ur quick reply.

Regards,

Nagarjuna

Highlighted
Master III
Master III

Re: Filter issue>>>>>Urgent

Cheers