Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Ok, I understood the opposite, then I think the NODISTINCT option given by sunny is what you are searching for.
Ruben, is this not going to work?
Count(Distinct TOTAL <Year> EmpID)
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.
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.
thanks Ruben