Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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],
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]
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]
Sunny,
Thanks for your reply it worked.
Tom
Awesome, I am glad it did. Please close the thread by marking the correct answer.
Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny