Predefined Values From 2 Fields

Tue, 16 Aug 2011 14:46:06 GMT

I'm wanting to have a predefined list of values for an input box coming from 2 fields, [Name] and [Name2], I currently have just [Name] in using the formula

=concat([Name],',')

Does anyone know how to do this for two fields at once so both sets of Names are in the dropdown?

Thanks

Re: Predefined Values From 2 Fields

matt_crowther — Tue, 16 Aug 2011 15:37:41 GMT

Without testing and they may not fit your situation but try:

1. Create a combined field in the load script using the '&' '&' method to join (don't think that's what you're after)

2. Try, =concat([Name],',')&', '&concat([Name2],',') - you can be quite flexible with the concat statement; I find the best way to ensure it's returning the correct results is to enter it into a text box first to make the results clear. Add a 'distinct' statement in to the concat() expression if you need to de-duplicate the list.

Hope that helps,

Matt - Visual Analytics Ltd

topic Re: Predefined Values From 2 Fields in QlikView

Predefined Values From 2 Fields

Re: Predefined Values From 2 Fields