topic Re: Addin New fields together in scripts in QlikView

Addin New fields together in scripts

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have created 2 new fields in my scripts and would like to add them together, can this be done in the same scripts??

if(NEW_THIS_MONTH_IND = 'Y' AND ASSIGNED_FIRST_TIME_THIS_MONTH_IND = 'Y', '1', '0') AS [NEW AND ASSIGNED],

If(ASSIGNED_FIRST_TIME_THIS_MONTH_IND = 'Y' AND NEW_THIS_MONTH_IND <> 'Y', '1', '0') AS [ASSIGNED NOT NEW COUNT],

I tried this but didn't work

Count(if([NEW AND ASSIGNED]+[ASSIGNED NOT NEW COUNT]))as [New and First Time Assignments],

sunny_talwar — Fri, 07 Oct 2016 17:33:42 GMT

May be like this:

RangeSum(

If(NEW_THIS_MONTH_IND = 'Y' AND ASSIGNED_FIRST_TIME_THIS_MONTH_IND = 'Y', '1', '0'),

If(ASSIGNED_FIRST_TIME_THIS_MONTH_IND = 'Y' AND NEW_THIS_MONTH_IND <> 'Y', '1', '0')

) as [New and First Time Assignments]

Anonymous — Fri, 07 Oct 2016 17:59:36 GMT

Sunny,

Thanks for your reply it worked.

Tom

sunny_talwar — Fri, 07 Oct 2016 18:21:44 GMT

Awesome, I am glad it did. Please close the thread by marking the correct answer.

Best,

Sunny