topic Re: multiple fields in one column in QlikView

multiple fields in one column

Mon, 28 May 2012 20:05:46 GMT

Hi there, I am trying to build out a list of recommended items to buy based on their attributes into a straight table. I have two fields. Items, which the customer bought and substitute items, which the customer could buy instead of what he bought. I need to have the two different fields populate in one column in the straight table. Is this possible? Thanks for the help!

multiple fields in one column

Jason_Michaelides — Mon, 28 May 2012 22:25:03 GMT

Can you supply some source data and how you want it to look?

Re: multiple fields in one column

Tue, 29 May 2012 00:21:29 GMT

Not sure if I address your problem here,

I had a request to join values from 2 fields values together and output to 1 column.

I used:

Concat( [Field1] & '-' & [Field2], ',', [Field1])

This will return a joined string of all values as "field1-field2" pairs seperated by commas from the same group and sorted by field1.

multiple fields in one column

Tue, 29 May 2012 14:32:16 GMT

Hi, thanks for the responses. What I have is, bought_item field. Lets say there are 3 items, 1,2,3. I have substitute_item, 4, that should be bought instead of bought_item 1. So, in my column I want to see recommended items to buy as items 2,3,4.

multiple fields in one column

Jason_Michaelides — Thu, 07 Jun 2012 07:16:31 GMT

Please supply a sample qvw so we can help you further. It is not clear from your posts what you are working with.

Thanks,

Jason