Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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_

Hey Ahmad,

Could you please send us an example app?

Cheers

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