Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Try this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

1 Reply
Anil_Babu_Samineni

Try this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)