Expression to get the concatenated string

[#1]

Hi , Can somebody please help me writing this expression please?

I have this comparitive analysis requirement where for selected 2 dates,I need to get the difference between those values for a given ID.

ID, attr, Date          , Vaue

1, a      ,  03/03/2014, 10

1, b      ,  04/03/2014 , 20

2, b      , 03/03/2014, 50

2, b      ,04/03/2014, 20

in the Qlikview repot, I have two filters Date1 and Date2 both are from Date.

ID , attr, Date1, Date2, Variance

1, a/b     , 10     , 20     ,  10

2, b        ,50     ,20     , 30

for ID2 it works fine, as the attr is same for both Date1 and Date2, but it does not work for ID1 as they are different.

I want to display either 'a' or 'b' or 'a/b' without displaying it as a seperate row.

Cansomeone please provide the expression to do so?

[jerem1234 · Accepted solution]

See if attached is what you are looking for: I just used the calculated dimension:

aggr(concat({1}distinct Attr, '/'), ID)

Hope this helps!

[veidlburkhard]

Hi Kalpana,

may be this simple solution is ok for you:

[#4]

Thank you Jeremy..! That works perfectly