topic Re: Expression to get the concatenated string in QlikView

Expression to get the concatenated string

Tue, 04 Mar 2014 14:37:00 GMT

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 — Tue, 04 Mar 2014 14:46:53 GMT

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 — Tue, 04 Mar 2014 15:15:58 GMT

Hi Kalpana,

may be this simple solution is ok for you:

Tue, 04 Mar 2014 15:22:02 GMT

Thank you Jeremy..! That works perfectly