topic Re: Show all attributes in one single column in QlikView

Show all attributes in one single column

ashishpalkar — Thu, 18 Feb 2016 15:29:47 GMT

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 — Thu, 18 Feb 2016 15:32:01 GMT

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

swuehl — Thu, 18 Feb 2016 15:36:13 GMT

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 — Thu, 18 Feb 2016 15:38:36 GMT

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 — Thu, 18 Feb 2016 18:51:07 GMT

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 — Fri, 19 Feb 2016 14:40:17 GMT

Hi Sunny

Any suggestions?

Thanks again...

ashishpalkar — Fri, 19 Feb 2016 21:05:46 GMT

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