topic Re: Expression consolidation in QlikView

Expression consolidation

Anonymous — Thu, 04 Feb 2016 05:45:22 GMT

Can the following two expressions be combined into one expression:

Thanking you in advance

Regards.

Re: Expression consolidation

Anonymous — Thu, 04 Feb 2016 05:56:05 GMT

like this?

=if(len(trim([Doctor Number]))=0, '00000',

if(len(trim([Doctor Number])) >=6 and [Retail Pharmacy]='PSMAS', '00001', [Doctor Number])) as [Doctor Number]

Re: Expression consolidation

jagan — Thu, 04 Feb 2016 06:03:56 GMT

HI,

Try like this

=If(Len(Trim([Doctor Number]))=0, '00000',

If(Len(Trim([Doctor Number])) >=6 AND[Retail Pharmacy]='PSMAS', '00001', [Doctor Number])) AS [Doctor Number]

Re: Expression consolidation

Anonymous — Thu, 04 Feb 2016 06:05:34 GMT

Many thanks Bairaj, i will try it out and advise outcome

Regards

Re: Expression consolidation

Anonymous — Thu, 04 Feb 2016 06:06:31 GMT

Thanks Jagan, i am trying this out and will let you know outcome

Regards.

Re: Expression consolidation

amit_saini — Thu, 04 Feb 2016 06:06:32 GMT

Hi Chris,

This should work:

Thanks,

Re: Expression consolidation

Anonymous — Thu, 04 Feb 2016 06:07:55 GMT

Amit may thanks i am trying this out

Re: Expression consolidation

avinashelite — Thu, 04 Feb 2016 06:43:20 GMT

if you have got the correct answer please mark the correct answer and close this thread

Re: Expression consolidation

Anonymous — Thu, 04 Feb 2016 06:59:49 GMT

Hi Balraj

Many thanks that works. i have problems with using the if(Len(Trim function on its own and want to incorporate it with the NULL function as follows:

if(len(trim([Doctor Number]) = 0 or If(IsNull([Doctor Number])), '00000', if(len(trim([Doctor Number])) >= 7 and [Retail Pharmacy]='PSMAS', '00001', [Doctor Number])) as [Doctor Number]

There is something wrong with the above expression and i am failing to figure out the error. Kindly assist

Re: Expression consolidation

amit_saini — Thu, 04 Feb 2016 07:05:54 GMT

Try:

if(IsNull([Doctor Number]),'00000',if(len(trim([Doctor Number])) >= 7 and [Retail Pharmacy]='PSMAS', '00001', [Doctor Number])) as [Doctor Number]

Thanks,

Re: Expression consolidation

Anonymous — Thu, 04 Feb 2016 07:12:45 GMT

Try this?

if(len(trim([Doctor Number])) = 0 or IsNull([Doctor Number]), '00000',

if(len(trim([Doctor Number])) >= 7 and [Retail Pharmacy]='PSMAS', '00001', [Doctor Number])) as [Doctor Number]

Re: Expression consolidation

Anonymous — Thu, 04 Feb 2016 07:14:24 GMT

With Isnull() , you dont required to write If() again...

It should be like this

if(len(trim([Doctor Number])) = 0 or IsNull([Doctor Number]),