Text values in Pivot chart

Wed, 21 May 2014 13:15:56 GMT

Hi, everybody!

I have a problem. It seems to be very simple, but i've got no solve.

I'll try to explain:

I got 2 tables - customer list and table with different contact and address text values. Key is CustomerID. I trying to make Pivot chart with dimension - CustomerName and expression - ContactInfo(contacts&address)

Customers:

CustomerID	CustomerName
1	A
2	B
3	C

Contacts:

CustomerID	ContactInfo
1	email@a.com
1	+438534593459
2	email@b.org
2	Moscow, blablabla street
3	+545458339423
2	+(968)56324564
3	ccc@wtf.net
1	Paris, champs elysee, 13

I want to make something like this (with grouping by Customer):

Customer	Contact Info
	email@a.com
	+438534593459
	Paris, champs elysee, 13
B	email@b.org
	Moscow, blablabla street
	+(968)56324564
C	+545458339423
C	ccc@wtf.net

But get only this:

Customer	Contact Info
A	email@a.com
B	email@b.org
C	+545458339423

or just empty chart.

What should i do with my expression or with something else?

Re: Text values in Pivot chart

Gysbert_Wassenaar — Wed, 21 May 2014 13:25:57 GMT

See attached example

Re: Text values in Pivot chart

Wed, 21 May 2014 13:29:37 GMT

Could you share your qvw? Are all those entries for contact info somehow linked to the customer in your data set?

Re: Text values in Pivot chart

Wed, 21 May 2014 14:08:04 GMT

Great Solution! Simple! And very simple) I spend fifteen minutes to understand how did you hide expression field)))

topic Re: Text values in Pivot chart in QlikView

Text values in Pivot chart

Re: Text values in Pivot chart

Re: Text values in Pivot chart

Re: Text values in Pivot chart