topic Re: how to filter the data with where condition in QlikView

how to filter the data with where condition

madhubabum — Tue, 30 Jun 2015 06:07:49 GMT

Hi all

I have FY2001,FY2002,FY2003,FY2004,FY2005 data set,

how can i get FY 2003 to FY 2004.......with the help of Where condition

Thanks

Madhu

Re: how to filter the data with where condition

MK_QSL — Tue, 30 Jun 2015 06:10:53 GMT

If you want at script level

Load * From TableName Where WildMatch(Year,'*2003',*2004);

If you want at front end

Something like below

SUM({<Year = {'*2003','*2004'}>}Sales)

Re: how to filter the data with where condition

Tue, 30 Jun 2015 06:10:55 GMT

Hi Madhu,

You can use

Where wildmatch(Year,'FY2003','*2004');

Thanks,

Garry

Re: how to filter the data with where condition

jsingh71 — Tue, 30 Jun 2015 06:14:58 GMT

Load * From ….. WHERE Match(Year, ‘2003’, ‘2004’)

Re: how to filter the data with where condition

madhubabum — Tue, 30 Jun 2015 06:18:18 GMT

Hi jsingh

Thanks to ur reply

I want to filter the data from "June-2003" to "may-2004"

Re: how to filter the data with where condition

Tue, 30 Jun 2015 06:19:10 GMT

Hi Madhu,

Load .... From ..... where Year>2003; this will give year from 2003 to......

Re: how to filter the data with where condition

jsingh71 — Tue, 30 Jun 2015 06:31:34 GMT

what is your Date field? Is there a field is available which contains values like June-2003, July-2003 and so on?

Re: how to filter the data with where condition

jsingh71 — Tue, 30 Jun 2015 06:35:12 GMT

Or share some sample data so its easy for us to give you correct solution.

Re: how to filter the data with where condition

krishna20 — Tue, 30 Jun 2015 06:37:24 GMT

Hi Madhu,

if you need to display 2003 & 2004 data at front end. Try MRKachhiaIMP

Second suggestion.It will works.

Re: how to filter the data with where condition

vcanale — Tue, 30 Jun 2015 08:35:22 GMT

Hi,

Try this:

Load 'AllFieldsYouNeed',

Date(MonthStart('YourDateField'), 'MMM-YYYY') as [MMM-YYYY]

from TableName

where [MMM-YYYY] > Jun-2003 and [MMM-YYYY] <May-2004;