repeating aggr value in straight table

[harleen_singh]

I Have a straight table like this. I want to repeat values in a column which is total of Asia+America using expression

let say if i use this formula  aggr( count(distinct EmpID),Year). it only returns one value .i.e 35 and 70 but doesn't repeat same in all the columns?

Any ideas?

Year	Region	Headcount	Total
2016	Asia	15	35
2016	America	20	35
2015	Asia	30	70
2015	America	40	70

thanks

[rubenmarin]

Ok, I understood the opposite, then I think the NODISTINCT option given by sunny is what you are searching for.

[sunny_talwar · Accepted solution]

Ruben, is this not going to work?

Count(Distinct TOTAL <Year> EmpID)

[Anil_Babu_Samineni]

Please refer this,

https://community.qlik.com/docs/DOC-8242

As i Understand, He don't have Total Column on his qvw, Might be you are expecting Total using three Dim's. I hope this helpful.

[rubenmarin]

Yes, it can work too, I mentioned the NODISTINCT because it's the more similar to the original expression, it only needs this keyword to repeat values.

But the other two can also work...well, the first one -Count(TOTAL <Year> Headcount)- needs a Sum() intead of a Count()... things of quick-answering i guess.

[harleen_singh]

thanks Ruben