topic Re: Column in straight table list all values in QlikView

Column in straight table list all values

jpapador — Mon, 25 Mar 2013 16:06:07 GMT

I have a table with multiple dimensios but one is date. Is it possible to have a column list it's values even if it is not specific to that date. For example:

CURRENT

Date Car CarId Serivce

1/23/2013 Ford 12 Oil Change

1/23/2013 Toyota 55 Brakes

1/31/2013 Ford 12 -

2/2/2013 Ford 12 Tire Rotation

2/4/2013 Toyota 55 -

2/6/2013 Toyota 55 Power Steering

What I would Like:

Date Car CarId Serivce

1/23/2013 Ford 12 Oil Change, Tire Rotation

1/23/2013 Toyota 55 Power Steering, Brakes

1/31/2013 Ford 12 Oil Change, Tire Rotation

2/2/2013 Ford 12 Oil Change, Tire Rotation

2/4/2013 Toyota 55 Power Steering, Brakes

2/6/2013 Toyota 55 Power Steering, Brakes

Is this possible?

Re: Column in straight table list all values

alexandros17 — Mon, 25 Mar 2013 16:08:45 GMT

Yes, try with If in the dimension field and set your condition

Re: Column in straight table list all values

jeffmartins — Mon, 25 Mar 2013 16:49:09 GMT

Hi jpapador,

You need to adjust your data model to get the services and dates related.

After relating the services and dates you can use the concat function to get the services separeted by comma at the same line.

Regards

Re: Column in straight table list all values

Mon, 25 Mar 2013 19:37:37 GMT

Assuming CURRENT is your data model, you can use the total key word with the concat function. Create a straight table with Date, Car, and CarId as the dimensions and use Concat(Total <Car, CarId> Service, ', ') as the expression.