Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor III

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

Re: TableBox

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)
1 Reply

Re: TableBox

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)