Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Didn't we work on something similar before? May be concatenate them together into one column? What are you exactly trying to do?
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
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
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..
Hi Sunny
Any suggestions?
Thanks again...
Triggers were added to select the fields. After removing triggers the issue is resolved...