Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have lot of duplicate values in a single field. I don,t want duplicate values.
Ex:
Field Name:
aa,
bb,
aa,
cc,
dd,
dd,
xx
Output:
aa,
bb,
cc,
dd,
xx
Regards,
Dinesh Kumar M.
Do you have other fields in this table where the value is not the same? for instance;
FieldName, FieldName2
aa, 1
aa, 2
If this is the case, how do you want to handle this? Sum(FieldName2) or an aggregation like that? If this is the only field, then you can use DISTINCT keyword after your load statement
LOAD DISTINCT FieldName
FROM....
Hi Sunny,
I want to write DISTINCT syntax in expression not in script without any arithmetic operation like count,sum,etc
Regards,
Dinesh Kumar M
just add DISTINCT key field before the filed name
Why duplicates showing, if you have only one list box then Qlikview default removes the duplicates. I think you might clear this
Where exactly are you using this as an expression?
In what object or chart are you writing the expression?
-Rob