topic Re: Match function in QlikView

Match function

nareshthavidishetty — Tue, 15 Sep 2015 04:34:24 GMT

Hi,

I have two tables one table contains column State which contains 1,2,3,4,5 and another table contains a column called state which contains Maharashtra,punjab,Haryana,Kerala.

Now i need to define a pivot table from both the table ,can you please define the process by using match function.

1=Maharashtra

2=punjab

3=Haryana

4=Kerala....

Re: Match function

robert_mika — Tue, 15 Sep 2015 04:37:13 GMT

Use Applymap in load statemtent (script) instead (this is faster that match)

Don't join - use Applymap instead

Feeling Qlikngry?

How To /Missing Manual(18 articles)

Re: Match function

sunny_talwar — Tue, 15 Sep 2015 04:37:42 GMT

Not sure what you mean, but Pick can work like this:

=Pick(StateNum, 'Maharashtra', 'Punjab', 'Haryana', 'Kerala')

Re: Match function

tresB — Tue, 15 Sep 2015 04:38:12 GMT

Are the tables linked? If linked properly, match() might not be required. QV does it by association automatically. Try to explain a bit more with data sample.

Re: Match function

PrashantSangle — Tue, 15 Sep 2015 04:39:16 GMT

Hi,

Can you some more details of both tables.

How they are associated with each Other???

Regards,

Re: Match function

nagarjuna_kotha — Tue, 15 Sep 2015 04:44:05 GMT

Can u share sample data ?

Re: Match function

engishfaque — Tue, 15 Sep 2015 06:17:22 GMT

Dear Naresh,

Here it is,

=Pick(wildmatch(YourFieldName, 'Maharashtra', 'Punjab', 'Haryana', 'Kerala', '*'), Red(), Green(), Blue(), Black(), LightGray())

Kind regards,

Ishfaque Ahmed