topic Re: using left statement in QlikView

using left statement

mustafaelryah — Tue, 27 Jan 2015 06:16:21 GMT

Dear All,

I need to sort my account column , example : 1101 , this is asset account because the first left digit is one , and 6021 is expense account because the first digit is 6, I used the below statement but I got an error :

if(Left("account",1) = 'asset') as "Account_Type" ,

//or ..

Re: using left statement

its_anandrjs — Tue, 27 Jan 2015 06:20:48 GMT

Hi,

Can you elaborate with an example

or you can try

if(Left("account",5) = 'asset') as "Account_Type"

Because the account has 5 words let me know

Regards

Anand

Re: using left statement

jonathandienst — Tue, 27 Jan 2015 06:22:39 GMT

QV field names are case sensitive - is the field name Account or account?.

As for your expression, based on your description, this what you need:

If(Left(account, 1) = '1', 'asset', If(Left(account, 1) = '6', 'expense', 'other')) As Account_Type,

HTH

Jonathan

Re: using left statement

Anonymous — Tue, 27 Jan 2015 06:25:17 GMT

Hello,

use this

if(Left(account,1)=1, 'asset',if(Left(account,1)=6,'expense','N/A')) as account_type

HTH

Re: using left statement

mustafaelryah — Tue, 27 Jan 2015 06:29:21 GMT

All correct answers , Thanks All ^_^,