Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

HOW TO CONCATENATE BOTH PIVOT TABLES TOGETHER

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??

1 Solution

Accepted Solutions
shaik_basha
Contributor III

Re: HOW TO CONCATENATE BOTH PIVOT TABLES TOGETHER

Hi, 

    Please find the attachment  and let me know,

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

Regards

5 Replies
shaik_basha
Contributor III

Re: HOW TO CONCATENATE BOTH PIVOT TABLES TOGETHER

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

Not applicable

Re: HOW TO CONCATENATE BOTH PIVOT TABLES TOGETHER

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

Not applicable

Re: HOW TO CONCATENATE BOTH PIVOT TABLES TOGETHER

Any more ideas ???

shaik_basha
Contributor III

Re: HOW TO CONCATENATE BOTH PIVOT TABLES TOGETHER

Hi, 

    Please find the attachment  and let me know,

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

Regards

Not applicable

Re: HOW TO CONCATENATE BOTH PIVOT TABLES TOGETHER

MAn this is a great idea. Many Thanks