Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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@

Capture1.PNG

2 Replies
Highlighted
Champion III
Champion 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?

Highlighted

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)