topic Re: if statements in QlikView

Creating new field depending on 3 more fields from source

dseelam — Sat, 16 Nov 2024 04:26:11 GMT

Hello All,

Can some help in creating a new field Closeouts with close out and Excl Close out values depending on below condition in the Picture

If closeout number has null begin date and end date the number should always falls under closeout

If closeout number has begin date would like to show that number under close out starting that date

if it has both begin and end date the number should fall under close out other then this condition everything should fall under excl close out

Re: if statements

Sue_Macaluso — Fri, 15 Feb 2019 19:13:26 GMT

Hi, What product are you using QlikView or Sense? I would like to move it to the appropriate product forum. Thanks

Re: if statements

dseelam — Fri, 15 Feb 2019 19:15:36 GMT

Hello Sue,

Its Qlikview

Re: Creating new field depending on 3 more fields from source

pradosh_thakur — Fri, 15 Feb 2019 19:59:20 GMT

The wordings was bit ambiguous. I am just writing a if clause , you jsut need to change the comments to what ever you desire

if(len(trim([Begin Date]))=0 and len(trim([End Date]))=0,'Closeouts',if(len(trim([End Date]))=0, 'Begining ' & [Begin Date] &' continuing ' ,'closed out during the time frame' &  [Begin Date] & [End Date]))

Please check for the field names case sensitivity.

Regards

Pradosh

Re: Creating new field depending on 3 more fields from source

dseelam — Fri, 15 Feb 2019 21:56:22 GMT

Thanks Pradosh,

Using your code took me some where but below code stuck my mind, it came with no errors but not deriving any results on front end

this is some thing am looking for but not derived results I need

if(len(trim(date([Begin Date])))=0 and len(trim(date([End Date])))=0 ,
if(len(trim(date([Begin Date])))>0 ,
if(len(trim( date([Begin Date] and date([End Date]>0)))),'Closeouts' ,'Excl Closeout'))) as Closeout

source data

Re: Creating new field depending on 3 more fields from source

pradosh_thakur — Sat, 16 Feb 2019 19:16:35 GMT

You didn't exactly used my expression. I am attaching the qvw . Please use it.