Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anonymous
Not applicable
Author

Hi, 

    Please find the attachment  and let me know,

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

Regards

View solution in original post

5 Replies
Anonymous
Not applicable
Author

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
Author

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
Author

Any more ideas ???

Anonymous
Not applicable
Author

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
Author

MAn this is a great idea. Many Thanks