Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
3 Keynotes, 100+ Breakout Sessions, 1 New York Times bestseller, and you. QlikWorld Online, May 10-12: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stuhico09
Creator
Creator

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
Specialist III
Specialist III

Hey Ahmad,

Could you please send us an example app?

Cheers

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