Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
vishalpujari22
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@

Capture1.PNG

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

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)