Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stuhico09
Contributor

Subtitle expression.

Hi. May I know why my number of task expression show different value when used in subtitle expression? What is the correct expression?

It show 43. what i want is 36.5

  • 42+31=73
  • 73/2= 36.5

Please help. Thanks,

Expression for number of task:

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

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

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

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


qq.PNG

1 Reply
thiago_justen
Valued Contributor III

Re: Subtitle expression.

Hey Ahmad,

Could you please send us an example app?

Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
Community Browser