Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor III

Count over aggr (in text object)

hello all  as you seen in screenshot x handled in UI level i.e Row no(Total) need to handle ever calculation in UI i want X  total count in Text object like if(Len(year)>0,count(Month)) in text object 18 count is refelecting

thanks in advance@


2 Replies
Esteemed Contributor III

Re: Count over aggr (in text object)

Not sure can you explain with your sample qvw?  or 

sample data with expected output you want to see?


Re: Count over aggr (in text object)

May be this? If you are expecting 17 in your KPI, Please use this?

count({<year = {"=Len(year)>0"}>} Month)

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)