topic Re: HOW TO CONCATENATE BOTH PIVOT TABLES TOGETHER in QlikView

HOW TO CONCATENATE BOTH PIVOT TABLES TOGETHER

Sun, 27 Jan 2013 18:28:51 GMT

Attached is my qvw. In management sheet there is 2 pivot tables which need to be grouped into one table

Anyone have an idea how this can be done??

Re: HOW TO CONCATENATE BOTH PIVOT TABLES TOGETHER

Anonymous — Sun, 27 Jan 2013 19:01:04 GMT

Dear bilalelabd,

create a inline table backend for those 13 exprsessions lables,that inline table is use full for merging a two pivot tables,other wise please provide a sample data ,i will provide a solution .

Regards

Re: HOW TO CONCATENATE BOTH PIVOT TABLES TOGETHER

Mon, 28 Jan 2013 06:50:11 GMT

I attached a simplied example.

the purpose of mergining is to have the following table

Expression Dec Jan jan V.s December average(all months)

---------------- ----- --------- ---------------------------- ----------------------------

Admission Q 98 90 ( 90-98)/98 (98+90)/2

Please reply as soon as possible. This is very important for me

Re: HOW TO CONCATENATE BOTH PIVOT TABLES TOGETHER

Mon, 28 Jan 2013 18:35:08 GMT

Any more ideas ???

Re: HOW TO CONCATENATE BOTH PIVOT TABLES TOGETHER

Anonymous — Mon, 28 Jan 2013 19:46:53 GMT

Hi,

Please find the attachment and let me know,

i written three expressinos only same way you want to implement another six measures.

Regards

Re: HOW TO CONCATENATE BOTH PIVOT TABLES TOGETHER

Mon, 28 Jan 2013 20:06:33 GMT

MAn this is a great idea. Many Thanks