topic Need a Help in If condition in QlikView

Need a Help in If condition

Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

I am having a problem with IF Condition Could some one can please help me in resolving Issue

Formula is Available in Text Object in Attached qvw Please It's very Important. It will be really Appreciable if some one helps me

Please find attached documents

Thank you,

Swarupaaa

Re: Need a Help in If condition

santiago_respane — Thu, 11 Aug 2016 14:13:36 GMT

Hi,

i think your IF statement is not well formed.

Maybe you can share what is your desired result in order to give you a more accurate solution.

Try this:

=if(len([Updated Date]) = 0,1,

if((Place = 'South' or Place = 'North') AND

[Updated Date] <=(FirstWorkDate([Finalised Date],[No of Days],$(Test_Holidays))) AND

([Place Code] = 'D21' AND [Place Code] = 'M01'),0,1))

Let me know if this helps.

Kind regards,

Re: Need a Help in If condition

squeakie_pig — Thu, 11 Aug 2016 14:28:13 GMT

Something like this might be what you are looking for

if(len([Updated Date]) = 0, 1,

if(match(Place, 'South','North') AND [Updated Date] <=(FirstWorkDate([Finalised Date],[No of Days],$(Test_Holidays))) AND match([Place Code], 'D21''M01'),

0,1))

It's not very clear what you're looking for though.

Re: Need a Help in If condition

squeakie_pig — Thu, 11 Aug 2016 14:31:34 GMT

Also, do you need the Place = North and South if you are using Place Code. In the sample you provided the Place Codes made this redundant, so the code below might be sufficient

=if(len([Updated Date]) = 0, 1,

if(match([Place Code],'D21','M01') AND [Updated Date] <=(FirstWorkDate([Finalised Date],[No of Days],$(Test_Holidays))),

0,1))

Re: Need a Help in If condition

Thu, 11 Aug 2016 14:35:28 GMT

Thank you for your response Santiago I will check and Let you know

Re: Need a Help in If condition

Thu, 11 Aug 2016 15:55:43 GMT

Hi Collete,

I have written code what you mentioned in script

Test:

LOAD [Updated Date],

[Finalised Date],

Place,

[Place Code],

[No of Days],

if(len([Updated Date]) = 0, 1,

if(match(Place, 'South','North') AND [Updated Date] <=(FirstWorkDate([Finalised Date],[No of Days],$(Test_Holidays))) AND match([Place Code], 'D21''M01'),

0,1)) as [Test]

FROM

xyz.qvw

It have to show 0,1 for Test. But it's showing only 1

Re: Need a Help in If condition

Thu, 11 Aug 2016 16:06:10 GMT

Actual Formula is

IF([Updated Date]="","1",

IF(AND([Place Code]="North",[Updated Date]<=(WORKDAY([Finalised Date],-6,Holiday)),(LEFT([Place Code],3)="D21")),"0",

IF(AND(LEFT([Place Code],3)="M01",[Updated Date]<=WORKDAY([Finalised Date],-6,Holiday)),"0",

IF(AND([Place Code]="South",[Updated Date]<=(WORKDAY([Finalised Date],-6,Holiday)),(LEFT([Place Code],3)="D21")),"0",

IF(AND(LEFT([Place Code],3)="M01",[Updated Date]<=WORKDAY([Finalised Date],-6,Holiday)),"0","1")))))

Thank you for your reply Collete

Re: Need a Help in If condition

Thu, 11 Aug 2016 16:06:55 GMT

IF([Updated Date]="","1",

IF(AND([Place Code]="North",[Updated Date]<=(WORKDAY([Finalised Date],-6,Holiday)),(LEFT([Place Code],3)="D21")),"0",

IF(AND(LEFT([Place Code],3)="M01",[Updated Date]<=WORKDAY([Finalised Date],-6,Holiday)),"0",

IF(AND([Place Code]="South",[Updated Date]<=(WORKDAY([Finalised Date],-6,Holiday)),(LEFT([Place Code],3)="D21")),"0",

IF(AND(LEFT([Place Code],3)="M01",[Updated Date]<=WORKDAY([Finalised Date],-6,Holiday)),"0","1")))))

Thank you for your reply Santiago. It is formula from excel

Re: Need a Help in If condition

squeakie_pig — Thu, 11 Aug 2016 16:25:24 GMT

Is there any values that meet the criteria for 0, from what I can tell they are all 1.... but it's been a long day so I could have misinterpreted a comma in there somewhere

Re: Need a Help in If condition

Thu, 11 Aug 2016 16:59:53 GMT

Thank you Kenny