Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bibopipo
Not applicable

References string

Hi,

I've the following table:

Customer  Order          Article          InvoiceNr      Amount

A               100               P1               Z1500          500

A               100               P1               Z2000          600

A               150               P2               Z2200          150

A               160               P2               Z2300          800

C               350               P3               Z2400          50

C               360               P3               Z2600          1800

and I've to produce the following report

Customer     Article     sum(Amount)          Invoice References

A                    P1          1100                    Z1500 - Z2000 

A                    P2          950                     Z2200 - Z2300

C                    P3          1850                    Z2400- Z2600

How can I concatenate all the Invoice number into a simpe string field like indicated above ?

Help please, thank to anybody can put me on the right track

  

1 Solution

Accepted Solutions
mayilvahanan
Not applicable

Re: References string

HI

Please check the attached file

Hope it helps

3 Replies
mayilvahanan
Not applicable

Re: References string

HI

Please check the attached file

Hope it helps

celambarasan
Not applicable

Re: References string

Check with this

Dimensions: Customer, Article

Expressions: Sum(Amount), Concat(Distinct InvoiceNr, '-')

Do you need like this?

bibopipo
Not applicable

Re: References string

GREAT !!

Thanks