topic Issue in expression in QlikView

Issue in expression

Mon, 04 May 2015 14:35:26 GMT

Hi,

I'm not getting values in my drop down.

I want to display Transaction Status as 'Customer Reviewing Quote' when value is 'Quote Sent' and

Transaction Status as 'Conditional Approval' when value is 'TFS - Conditional Approval'

and default values for other values.

I wrote my expression as

if(wildmatch(([Transaction Status] = 'Quote Sent') , 'Customer Reviewing Quote'),

if(wildmatch(([Transaction Status] = 'TFS - Conditional Approval'), 'Conditional Approval'),[Transaction Status]))

Can some one please help me with this issue

Regards,

Aditya

Re: Issue in expression

ali_hijazi — Mon, 04 May 2015 14:37:47 GMT

you have a syntax error

you need to write if(wildmatch([Transaction Status],'Quote Sent')>0,Customer Reviewing quote',

if(wildmatch([Transaction Status],'tfs-conditional approval')>0,'Conditional Approval',[Transaction Status]))

Re: Issue in expression

sunny_talwar — Mon, 04 May 2015 14:42:45 GMT

Or a simpler version could be like this:

=If([Transaction Status] = 'Quote Sent', 'Customer Reviewing Quote',

If([Transaction Status] = 'TFS - Conditional Approval', 'Conditional Approval', [Transaction Status]))

Re: Issue in expression

Mon, 04 May 2015 14:46:34 GMT

Thank you SunIndia, it worked.

Re: Issue in expression

sunny_talwar — Mon, 04 May 2015 14:47:50 GMT

Awesome! I am glad that it worked

Best,

Sunny

Re: Issue in expression

stigchel — Mon, 04 May 2015 14:48:43 GMT

It would be better to do this in the load script with a mapping laod and Applymap functionality. In the gui you can use

=Aggr(Replace(Replace(TransactionStatus,'TFS - Conditional Approval','Conditional Approval'),'Quote Sent','Customer Reviewing Quote'),TransactionStatus)