Qlik Sense subtitle expression

[Anonymous]

Hi Everyone,

How to correct my subtitle expression. I use the same expression for my measure and subtitle but it show different value.

Based on my checking, it somehow include the task with "not started" status.

Please help. Thanks.

Expression:

=Num(Count({$<[SR No]={"=Min ({<Temp = {'Task_1'}>}[Date Created]) >=  MakeDate(2018,1,15)"}>

*$<Status={'Completed'}>*$<[SR No]-={"''"}> *$<Temp={'Task_3'}>

*$<[Date Modified.autoCalendar.YearMonth]={">=$(=AddMonths(MonthStart(Today()-20),-11))"}>

} ([SR No])),'##.0')

[Sheet1]:

LOAD [SR ID],

[Title],  

      if(wildmatch(Title,'*Submit*'),'Task_1',

    if(wildmatch(Title,'*Approve*'),'Task_2',

        if(wildmatch(Title,'*Update*'),'Task_3'

    )))  as Temp,

[Status],

[Date Created],

[Date Modified]

FROM [lib://demo/Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

[Sheet2]:

LOAD [ID] as [SR ID],

[SR No]

FROM [lib://demo/Book1.xlsx]

(ooxml, embedded labels, table is Sheet2);

[Anil_Babu_Samineni]

It picks for all data points, But, For change Null also considering. I think you could need work around. Can you suppress in Measure for null defines?

[Anonymous]

Dear Anil,

If i exclude the null,  I can get the number in the bar chart. but how to make my subtitle expression showing the same number as bar chart?

stalwar1‌

[Anil_Babu_Samineni]

Can i get your sample application?

[Anonymous]

Dear Anil,

As attached. Thanks.

[fabdulazeez]

If its an average than we are diving by 3 (number of distinct tasks). Than value for subtitle expression is fine as it will 12/3 .

[sunny_talwar]

May be this

=Num(Count(DISTINCT {$<[SR No]={"=Min ({<Temp = {'Task_1'}>}[Date Created]) >=  MakeDate(2018,1,15)"}>

*$<Status={'Completed'}>*$<[SR No]-={"''"}> *$<Temp={'Task_3'}>

*$<[Date Modified.autoCalendar.YearMonth]={">=$(=AddMonths(MonthStart(Today()-20),-11))"}> }

(If(Len(Trim([Date Modified])) > 0, [SR No]))),'##.0')

[pablolabbe]

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others