topic Re: Count over aggr (in text object) in QlikView

Count over aggr (in text object)

agastya — Sat, 24 Feb 2018 06:25:18 GMT

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@

Re: Count over aggr (in text object)

Chanty4u — Sat, 24 Feb 2018 16:22:43 GMT

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)

Anil_Babu_Samineni — Sat, 24 Feb 2018 16:40:47 GMT

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

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