topic Qlik Sense subtitle expression in QlikView

Qlik Sense subtitle expression

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

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);

Re: Qlik Sense subtitle expression

Anil_Babu_Samineni — Sat, 24 Feb 2018 16:58:42 GMT

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?

Re: Qlik Sense subtitle expression

Anonymous — Mon, 26 Feb 2018 06:01:23 GMT

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‌

Re: Qlik Sense subtitle expression

Anil_Babu_Samineni — Mon, 26 Feb 2018 07:41:22 GMT

Can i get your sample application?

Re: Qlik Sense subtitle expression

Anonymous — Mon, 26 Feb 2018 08:01:43 GMT

Dear Anil,

As attached. Thanks.

Re: Qlik Sense subtitle expression

fabdulazeez — Mon, 26 Feb 2018 08:02:21 GMT

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 .

Re: Qlik Sense subtitle expression

sunny_talwar — Mon, 26 Feb 2018 12:54:20 GMT

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')

Re: Qlik Sense subtitle expression

pablolabbe — Wed, 28 Feb 2018 09:08:09 GMT

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