topic Re: Match function in QlikView

Match function

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

I am trying to using match function in the following expression, please suggest the correct way of using it. I using the following but there is error in expression in drill down group.

IF([CountryRegion.Region]='China','China'
IF([CountryRegion.Region]='Norway','Norway'
If(Match([CountryRegion.Region]='Sweden', 'Denmark' , 'Finland','EU'
IF([CountryRegion.Region]='France','France' ))))

Thank you

Re: Match function

its_anandrjs — Thu, 21 Sep 2017 13:12:26 GMT

Try these ways

IF([CountryRegion.Region]='China','China',

IF([CountryRegion.Region]='Norway','Norway',

If( Match ( [CountryRegion.Region],'Sweden', 'Denmark') , 'Finland',

IF([CountryRegion.Region]='France','France','EU'))))

Re: Match function

hari8088 — Thu, 21 Sep 2017 13:12:33 GMT

Try this....

IF([CountryRegion.Region]='China','China'
IF([CountryRegion.Region]='Norway','Norway'
If(Match([CountryRegion.Region]='Sweden', 'Denmark' , 'Finland'),'EU'
IF([CountryRegion.Region]='France','France' )))

Re: Match function

sudeepkm — Thu, 21 Sep 2017 13:14:43 GMT

IF([CountryRegion.Region]='China','China',
IF([CountryRegion.Region]='Norway','Norway',
If(Match([CountryRegion.Region],'Sweden', 'Denmark' , 'Finland'),'EU',
IF([CountryRegion.Region]='France','France' ))))

if your requirement is to replace the existing value of a field with a new value then you can manage that at script level by using mapping load and applymap function.

Create a map table using mapping load that will have two fields From, To.

and then call applymap function by passing the current value and get the new values as a new field.

Re: Match function

its_anandrjs — Thu, 21 Sep 2017 13:17:31 GMT

Earlier was typo and saved try this one

IF([CountryRegion.Region]='China','China',

IF([CountryRegion.Region]='Norway','Norway',

If( Match ( [CountryRegion.Region],'Sweden', 'Denmark','EU') = 1, 'Finland',

IF([CountryRegion.Region]='France','France'))))