topic Re: merging charts in QlikView

merging charts

Tue, 01 Dec 2015 01:28:00 GMT

Hi friends,

I am having the below three fields(currency,product,intrest rates) to create the chart, i created three different charts using the currency,but

business people want me to create a single chart like below and i have to include group feild also which is hard coded by them.

when they export to excel the same pattern should come in the excel.

please help me if any one knows....

Currency	group	Product	Intrest rates
			0-30d	31-90d	91-180d	181-360d
SGD	Assets - On-balance Sheet	Loans - Fixed Rate	8,323	19,608	2,549	(6,343)
SGD	Derivatives - Off-balance Sheet	Loans - Floating Rate (SOR)	(821)	(1,223)	(89)	(224)
SGD	Liabilities - On-balance Sheet	Fixed Deposits	-	-	-	-

USD	Assets - On-balance Sheet	Loans - Fixed Rate	8,323	19,608	2,549	(6,343)
USD	Derivatives - Off-balance Sheet	Interest Rate Swaps	8,323	19,608	2,549	(6,343)
USD	Liabilities - On-balance Sheet	Cross Currency Swaps	(821)	(1,223)	(89)	(224)

EUR	Assets - On-balance Sheet	Loans - Fixed Rate	8,323	19,608	2,549	(6,343)
EUR	Liabilities - On-balance Sheet	Loans - Floating Rate (SOR)	(821)	(1,223)	(89)	(224)
EUR	Derivatives - Off-balance Sheet	Cross Currency Swaps	(821)	(1,223)	(89)	(224)

settu_periasamy — Tue, 01 Dec 2015 13:50:40 GMT

Hi,

How do you classify your Group? If it is based on your Breakdown field, you can just Load with Inline Table using the Keyfield of Breakdown.

Or you can Join your Group field Into your "IR" Table using the ApplyMap.

I just Load the sample table for Group and Breakdown. You can create your own Group based on your Breakdown field.

Check the attachment.

Wed, 02 Dec 2015 01:21:30 GMT

Hi,

Thank you so much for the reply, and it is working ,

my issue is how i can merge the above three currencies in a single chart?

settu_periasamy — Wed, 02 Dec 2015 07:31:37 GMT

I didn't get you. Can you please tell the example expected output?

Edit:

I updated the Currency using the ApplyMap I have loaded the Inline Currency Table.

Check the Attachment.