Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master
‎2017-10-15 04:58 AM

TableBox

Hi all

I am using KPI object to show the count of expression ,but my user want that details below the table box also

am using this expression working fine

508 Views
0 Likes
1 Solution

Accepted Solutions
Anil_Babu_Samineni
MVP
MVP
‎2017-10-15 05:42 AM

Try this?

=Count(aggr(If(TStatus='Closed','NA', only({$<Flag={0},[TStatus]={'Open'}>}TNumber)),TNumber))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

425 Views
1 Reply
Anil_Babu_Samineni
MVP
MVP
‎2017-10-15 05:42 AM

Try this?

=Count(aggr(If(TStatus='Closed','NA', only({$<Flag={0},[TStatus]={'Open'}>}TNumber)),TNumber))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
426 Views