Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stuhico09
Contributor

How to combine this two formula?

Hi. Any idea on how to make it one expresion? Thanks.

First formula

=  '= '  & (num((count (if( [Date Created] >  MakeDate(2018,1,15) and

Status='Completed'and [SR No]<>('') and Temp=('Task_2')  and

[Date Modified.autoCalendar.YearMonth]>= (AddMonths(MonthStart(Today()-20),-11))

,[SR No]))),'##.0')) &' task'

Second formula

=if(Temp='Task_1' and Min([Date Created]>MakeDate(2018,1,15)),[SR No])

2 Replies
YoussefBelloum
Esteemed Contributor

Re: How to combine this two formula?

Hi,

you just want to concatenate these two expressions to see the result in one line ?

if they already works, just link them by an & like this:

=  '= '  & (num((count (if( [Date Created] >  MakeDate(2018,1,15) and

Status='Completed'and [SR No]<>('') and Temp=('Task_2')  and

[Date Modified.autoCalendar.YearMonth]>= (AddMonths(MonthStart(Today()-20),-11))

,[SR No]))),'##.0')) &' task'&if(Temp='Task_1' and Min([Date Created]>MakeDate(2018,1,15)),[SR No])

Digvijay_Singh
Honored Contributor III

Re: How to combine this two formula?

May be like this -


=  '= '  & (num((count (

    if(      [Date Created] >  MakeDate(2018,1,15) and

              Status='Completed'and [SR No]<>('') and

              (Temp='Task_2' or  (Temp='Task_1' and Min([Date Created])>MakeDate(2018,1,15))) and

              [Date Modified.autoCalendar.YearMonth]>= (AddMonths(MonthStart(Today()-20),-11)) and

                Temp='Task_1' and Min([Date Created]>MakeDate(2018,1,15))

              ,[SR No],

))),'##.0')) &' task'

Community Browser