topic Re: match function in qlikview in QlikView

match function in qlikview

Anonymous — Thu, 13 Nov 2014 05:12:07 GMT

hi all ,

i have years from 2000 to 2015 .Now i am trying to print years from 2005-2012 .How to do it with match() rather than hard coding the years from 2005-2012 .

Thanks

Re: match function in qlikview

amit_saini — Thu, 13 Nov 2014 05:20:56 GMT

Hi,

See the attachment.

Thanks,
AS

Re: match function in qlikview

sujeetsingh — Thu, 13 Nov 2014 05:36:33 GMT

The Match() function can be used to compare strings, fields and variables using the string expression. The result of comparison is always an integer that shows the match expression. In the Match() function if no value is returned then the result would be 0. If an integer value is returned then the result would be 1. This function can used with the expression and it cannot be used with a chart, list box or text box. The Match() function will be used for a specified item in an array and then return the item in a specified position in a specified order. In the Match() the comparison is case sensitive.

Where to use Match() function

The Match() function can be used in a QlikView application for the "Switch Case" statement.
It can be also used as a substitution in an If statement.
It can be used in a Load Script as an In statement.
It can be used to find a match without using the duplicate value.

Re: match function in qlikview

sujeetsingh — Thu, 13 Nov 2014 05:37:20 GMT

This too can help you

The match function is a way to avoid writing

Load ...

From ...

Where Customer = 'A' or Customer ='B' or Customer='C'

and write it as

Load ...

From ...

Where match(Customer, 'A','B','C')

and it comes in a variety of flavors. WildMatch() is usually my favorite.

Re: match function in qlikview

jagan — Thu, 13 Nov 2014 05:39:00 GMT

Hi,

Try like this

If(Year >= 2005 AND Year <= 2015), Year)

with Match() it is not possible with out hard coding.

Regards,

Jagan.

Re: match function in qlikview

Thu, 13 Nov 2014 05:44:54 GMT

try like this

load

from sales .exl

where match (Year,'2005','2006','2007','2008','2009','2010','2011','2012','2013',2014','2015');

where not match(year,'2000','2001','2002','2003');

Re: match function in qlikview

its_anandrjs — Thu, 13 Nov 2014 05:57:19 GMT

Hi,

Instead of Match() you can try this with simple less than and equal to options

LOAD * Inline

[ Years

2001

2002

2003

2004

2005

2006

2007

2008

2009

2010

2011

2012

2013

2014 ];

NoConcatenate

LOAD

Years

Resident R

Where Years >= 2005 and Years <= 2012;

Regards

Anand

Re: match function in qlikview

Anonymous — Thu, 13 Nov 2014 06:49:23 GMT

Thank u all

Re: match function in qlikview

jagan — Thu, 13 Nov 2014 07:24:18 GMT

Close this thread by giving correct and helpful answers.

Regards,

Jagan.

Re: match function in qlikview

shiveshsingh — Mon, 04 Dec 2017 13:28:18 GMT

NoConcatenate

LOAD

Years

Resident R

Where Years >= 2005 and Years <= 2012;

After this, i think u need to drop table R as well

Re: match function in qlikview

bvssudhakar — Thu, 22 Mar 2018 09:10:44 GMT

Hi,

I have a urgent requirement, here i attached one qvw file in that filter i have 6 set of filters

Now i want to show the AND condition for those filter sets (data which will satisfy all the 5 filters applied.) which means the data which matches all the filters in 5 sets should only display in the result chart / table.

Can you guys help me out from this, It is an urgent Requirement

Kindly help me

Thank you in advance

Regards

Sudhakar

Re: match function in qlikview

shiveshsingh — Thu, 22 Mar 2018 10:08:59 GMT

Can you elaborate a bit, like what do you want to see in your chart? only data related to 5 filters?

Re: match function in qlikview

bvssudhakar — Thu, 22 Mar 2018 11:23:35 GMT

No, Matching values of those filters like

OrderID	Order date	Category Name	Product Name	Customer	Sales Person	Quantity
2422	2/16/2012	Baby Clothes	Aino Shoes	Halle Köln	Bob Park	41
2422	2/16/2012	Baby Clothes	Deuce Shirt	Halle Köln	Bob Park	11
4665	1/21/2013	Baby Clothes	Aino Shoes	La Moda d'il Futuri	Ricardo Gucci	61
4665	1/21/2013	Baby Clothes	Deuce Shirt	La Moda d'il Futuri	Ricardo Gucci	12
681	1/12/2011	Baby Clothes	Aino Shoes	Grunewald	Frank Roll	22
684	1/12/2011	Baby Clothes	Aino Shoes	Bond Ltd	Rob Carsson	21
714	1/30/2011	Baby Clothes	Aino Shoes	Boleros	Mike Ashkenaz	25
1116	6/20/2011	Baby Clothes	Aino Shoes	Art et Fashion	Lennart Skoglund	14
1131	6/25/2011	Baby Clothes	Aino Shoes	De la Vita	Lennart Skoglund	8
6241	12/10/2013	Baby Clothes	Deuce Shirt	Le Sais de Rión	Michelle Tyson	150
6247	12/13/2013	Baby Clothes	Deuce Shirt	The Corner Store	Rob Carsson	153
6276	12/20/2013	Baby Clothes	Deuce Shirt	Gluderstedt	Bob Park	19
6340	1/2/2014	Baby Clothes	Deuce Shirt	Boleros	Mike Ashkenaz	105
6341	1/3/2014	Baby Clothes	Deuce Shirt	Rode & Vite	Lennart Skoglund	6
6357	1/7/2014	Baby Clothes	Deuce Shirt	Too Hot 4U	Rob Carsson	155
6369	1/12/2014	Baby Clothes	Deuce Shirt	De la Vita	Lennart Skoglund	11
6433	2/3/2014	Baby Clothes	Deuce Shirt	La Legion Mercenaire	Michelle Tyson	147

This is my table

if i select Baby clothes, Aino Shoes, 2012 for filter 1 and for filter 2 Baby clothes, Deuce Shirt, 2013 then the out put will come like this

2422	2/16/2012	Baby Clothes	Aino Shoes	Halle Köln	Bob Park	41
2422	2/16/2012	Baby Clothes	Deuce Shirt	Halle Köln	Bob Park	11
4665	1/21/2013	Baby Clothes	Aino Shoes	La Moda d'il Futuri	Ricardo Gucci	61
4665	1/21/2013	Baby Clothes	Deuce Shirt	La Moda d'il Futuri	Ricardo Gucci	12

Help me out from this.... it's a very urgent requirement

Already i attached the qvw file also