Show all attributes in one single column

[ashishpalkar]

Hi Experts

Suppose I have 5 attributes Country, Name, Revenue , Emp Id and Date.

In Qlikview chart objects instead of showing all objects in different columns , want to show them in one single column.

any suggestions?

thanks in advance

[sunny_talwar]

Didn't we work on something similar before? May be concatenate them together into one column? What are you exactly trying to do?

[swuehl]

Yes, concatenation should do what you described:

=Country & Name & Revenue & [Emp Id] & Date

Add better delimiters etc. just by inserting literal text:

=Country & ' - ' & Name & ' - ' & Revenue &' - ' & [Emp Id] & ' - ' & Date

[Mark_Little]

HI,

Think Sunny suggestion is correct, but i don't really follow what you'e trying to achieve?

Is this for a selector?

You mention about it a chart, can you share what your are seeing in QlikView at the moment and what your are wanting to see.

Mark

[ashishpalkar]

Hi Sunny

thanks for the reply,

Please find attached sample QVW.

Here in this scenario 2 list boxes are created and they are added in container.

Using Chart table attributes are added in the table.. These attributes are conditionally selected.

One more list box created to combine both list boxes into one, (which we had discussed earlier)

Now using the combined list box attributes should be able to select / unselected..

Hope this helps..

[ashishpalkar]

Hi Sunny

Any suggestions?

Thanks again...

[ashishpalkar]

Triggers were added to select the fields. After removing triggers the issue is resolved...