topic Condition Not working in QlikView

Condition Not working

abhaysingh — Thu, 25 Feb 2016 13:09:13 GMT

Hi guys,

I m writing very simple if condition and strange its not working,,pls suggest

if((GL_CC_Flag=1 and (Cost_Center)= 'NA' ), Cost_Center=19001,0) as TestCenter;

i want where if((GL_CC_Flag=1 and (Cost_Center)= 'NA' ), will true cost centre will feed as 19001

when i m doing below for testing its working means giving output 1 but in above giving output 0

if((GL_CC_Flag=1 and (Cost_Center)= 'NA' ), 1,0) as TestCenter;

pls suggest

Re: Condition Not working

sunny_talwar — Thu, 25 Feb 2016 13:12:07 GMT

Try this:

If(GL_CC_Flag = 1 and Cost_Center = 'NA', '19001,0', Cost_Center) as Cost_Center;

Re: Condition Not working

Anonymous — Thu, 25 Feb 2016 13:25:12 GMT

How can you assign Cost_Center=19001? Will this work?

try like this?

if((GL_CC_Flag=1 and Cost_Center= 'NA' ), 19001,Cost_Center) as Cost_Center;

Re: Condition Not working

abhaysingh — Thu, 25 Feb 2016 13:51:08 GMT

even not working

Re: Condition Not working

Anonymous — Thu, 25 Feb 2016 13:55:31 GMT

what error you are getting?

Sample?

Re: Condition Not working

Thu, 25 Feb 2016 13:56:54 GMT

The conditions are diferents;

Tell us what do you want to do?

It is a very thin error. Asing:: Cost_Center=19001, in fact, it could be on another script, Cost_Center=0.

It is true?

Re: Condition Not working

abhaysingh — Thu, 25 Feb 2016 13:58:52 GMT

No error still getting NA

Re: Condition Not working

Digvijay_Singh — Thu, 25 Feb 2016 13:59:29 GMT

Do you want to assign 190001 to TestCenter when both conditions are true? If yes, then I think below should work.

if(GL_CC_Flag=1 and Cost_Center= 'NA',19001,0) as TestCenter

Re: Condition Not working

Anonymous — Thu, 25 Feb 2016 14:03:01 GMT

try this?

if(GL_CC_Flag=1 ,

if(Cost_Center= 'NA', '19001')) as Cost_Center

Re: Condition Not working

Thu, 25 Feb 2016 14:04:08 GMT

Do you are sure that the condition are true? Is it fullied?

Re: Condition Not working

engishfaque — Fri, 26 Feb 2016 06:57:13 GMT

Dear Abhay,

Kindly share your sample data as the condition can be make properly.

Kind regards,

Ishfaque Ahmed