Displaying no of Rows

Anonymous — Thu, 31 Mar 2016 17:07:18 GMT

Can someone helping me in fixing the expression for displaying the total Rows in the table , I have 2 ways of selecting service api value , one from Group:Service API filter and other way from Function in the Table , when user selects a Service api (function)value from Table the total number of rows count messes up in the Caption , please take a look at the attached file

Thank you

Re: Displaying no of Rows

sunny_talwar — Thu, 31 Mar 2016 17:15:28 GMT

May be use this expression:

=Count(Aggr(If(vFilterCheck,

If(only({<ServiceTimeSeries.Date={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}RequestCount_All) >100,only({<ServiceTimeSeries.Date={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}RequestCount_All))

,only({<ServiceTimeSeries.Date={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}RequestCount_All) ), ServiceTimeSeries.Date, FCIGroup, Function, TP50, TP90, TP999))

topic Re: Displaying no of Rows in QlikView

Displaying no of Rows

Re: Displaying no of Rows