show 1:M data in qlikview straight table

[qliklearnervir]

Hi,

I have to show my data as given below:

ID          Booking                   Villa Number

1           BO!                               V01

2           B02                               v03

i have to show this data in straight table but the issue is that .......

for example ID 1 have booked 2 villa but we can only show 1 villa number in the field.

in my case data is coming as blank........................i have some other record where 1 ID have booked more than 5 VIlla ...kindly suggest .

AND WE DONT WANT DUPLICATE DATA

but my major goal is to pick idS BUT vILLA NUMBER SHOULD NOT BE NULL ...

[swuehl]

Use aggregation functions in your expression, for Villa Number maybe Concat():

Dimensions:

ID

Booking

Expression:

=Concat(DISTINCT [Villa Number], ', ')

Use Aggregation Functions!

[asgardd2]

FOR NOT SHOW DUPLICATE - Use Concat() function in script (table 1 in attachment), and you can use "Table Box" object in dashboard.

FOR SHOW DUPLICATE  - You can add a new field in data model, for example "RowNumber". And add this field for a  hidden field in straight table. (table 2 in attachment)

See  attachemnt.

[Peter_Cammaert]

Or use a pivot table. One of the nice things about a pivot table in QlikView is that you can make it to look like a straight table without ever repeating dimension values.

Peter