Concat of 1 field and multiple link

[#1]

i have table as following:

CLIENT	INVOICE
1	1234
1	4321
1	3321
2	4564
2	4145
2	1235

I want to concat fiel Invoice in one field, and when i click, i can open a hyper link of each Invoice  , like this

CLIENT	concat(INVOICE)
1	1234;  4321; 3321
2	4564; 4145; 1235

How to do

[IAMDV]

Hi,

Something like this?

Cheers,

DV

www.QlikShare.com

[marcus_sommer]

If you concat(INVOICE) you couldn't use this as link to a single Invoice. You will need a chart-table with CLIENT and INVOICE as dimension and a hyperlink-expression or an OnSelect-Trigger on INVOICE which build and opened the link-url.

- Marcus

[IAMDV]

I personally prefer the attached option. I've used Pivot table and it's easily manageable.

Cheers,

DV

www.QlikShare.com

[#5]

Could you please attache your doc , u forgotte it

[IAMDV]

Hi,

I can see the attachment. Please can let me know if you can't see it.

Thanks,

DV

[#7]

OK, i can see it, thank you

[IAMDV]

Great. Have you managed to solve the issue? If yes, please can you close this thread by marking answers and/or helpful answer?

Thanks,

DV

www.QlikShare.com