topic Re: Match cases in QlikView

Match cases

noman212 — Tue, 10 Jun 2014 11:03:40 GMT

Hi all,

i have values in data bases 'Y','D','I' and so on i want to display on selection if i select Y then textbox show 'Premium' if D then it becomes difference.how can i do this?please tell

Re: Match cases

tresB — Tue, 10 Jun 2014 11:06:18 GMT

=Match(YourDataField, 'Y', 'D', 'I', ....), 'Premium', 'Difference', ....)

Re: Match cases

noman212 — Tue, 10 Jun 2014 11:21:17 GMT

Not showing any result

Re: Match cases

tresB — Tue, 10 Jun 2014 11:29:57 GMT

Note: To get a result, you have to select a value from data field.

Re: Match cases

noman212 — Tue, 10 Jun 2014 11:46:53 GMT

Re: Match cases

noman212 — Tue, 10 Jun 2014 11:47:35 GMT

i select field but it display none

Re: Match cases

anbu1984 — Tue, 10 Jun 2014 11:51:11 GMT

Can you attach your app.

Re: Match cases

Anonymous — Tue, 10 Jun 2014 11:54:02 GMT

It seems there is no connectivity between the fields.

I hope you have two different databases,but check your table viewer whether it has the connectivity.

Re: Match cases

noman212 — Tue, 10 Jun 2014 11:57:44 GMT

yes how can i connect these two fields

Re: Match cases

Anonymous — Tue, 10 Jun 2014 11:59:58 GMT

send me the sample app or send me the list of fields in two databases.

Re: Match cases

noman212 — Tue, 10 Jun 2014 12:02:05 GMT

M USING THESE TABLES

Re: Match cases

Anonymous — Tue, 10 Jun 2014 12:06:01 GMT

Just a thought,not sure this is what the issues,

Rename all your NPH_Code like below in all the tables

NPH_Code as NPC

Re: Match cases

ashfaq_haseeb — Tue, 10 Jun 2014 12:14:40 GMT

Hi noman,

you can use pick and match as shown below.

LOAD *,pick(Match(NPH_PRIMUS,'A', 'D', 'E','I','Y'), 'Premium', 'Difference','Ultra','ISO','Super' ) AS DESCRIPTION;

Load * inline

[

NPH_PRIMUS

];

Regards

ASHFAQ