Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

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
We are aware of an issue with the Product Downloads page and looking into it.
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

Labels (1)
Labels
1,114 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

1,031 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
1,032 Views