Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm Traying to use the function Distinct for eliminate duplicate text.
like:
P
P
A
M
M
S
I need
P
A
M
S
I have =Concat(Distinct(Field))
But appear an error.
Thanks
Hi
Normally, the rows with the same value get aggregated in the chart anyway. There is no need for a calculated dimension for this purpose. Just use the field as a dimension.
Regards
Jonathan
You don´t need this, if you use a field as dimention, QV will use only distinct values.
I tried:
=Concat(Distinct Field)
Nothing Happened.
I put my field as a dimension this is my result for 1 account:
Sells
Sells
Sells
Sells
Sells
So on
I think with concat and distinct functions should be working.I think something missing
Could you post a sample of your app?
Thank you for your replys guys. I can't send you a sample because my model is too heavy 300MB. But I Attached a file picture That I have.
Thank you!
Please send a pic of your Dim and Expressions tabs