Modelisation Problem

[#1]

Hello Evereybody :

I have a table :

CCN	Name	SN	Units
11100_FRA000094242	Sophie Loft	26105656112103	12
11100_FRA000094242	Sophie Loft	266434257352123	18

  In my Dashboard i want to have

Sophie    Loft ======================> CCN 1:  11100_FRA0000990158 ,   Units : 12

                                                                    CCN2 : 11100_FRA0000980114  , Units  18      

Maybe i Should use a concatenation    ???

[giakoum]

really not very clear what you are trying to achieve. Please elaborate a little.

[datanibbler]

Hi Ben Bourahel,

yes - you need a concatenation (the &, upper_quotes for the text_elements) and a rowno() for that "CCN1 CCN2".

[IAMDV]

Hi Ben,

Yes, you can use string concatenation but which object are you using? Please can you give more details. I can't fully follow your question.

Thanks,

DV

[#5]

IOANNIS

In this example, I have the same person (sophie) , with two different CCN and SN numbers ,So  what I want to do is: for the same person display the total of such units( units of sophie)

[giakoum]

a straight table with Name as dimension and sum(units) as expression would do it. Or a pivot, so that you can also show details like CCN and SN.

Hope I understood well

[IAMDV]

Hi Ben,

Try creating a unique field which is concatenation of all the fields with Autonumber() or Hash key. Then use this field as the hidden dimension and show other required dimensions.

Thanks,

DV

[#8]

Hello , Deepak ,

See a little example in the attachement

[#9]

Do you have an example please  ,  I debuted on qlikview

[giakoum]

see attached