How to do the chart ?

[suvechha_b]

Hi All ,

I got two different reports on my qlikview model .

How can I merge them into one ?

So , the two reports needs to be one .

Sample attached.

[suvechha_b]

It is correct but

I can't even copy the object. and I need to export the report to excel.

[vinieme12]

these are two tables stacked on top of each other! Got to Settings>Sheet properties >security

[Anil_Babu_Samineni]

What macro you've tried to send those reports into Excel. If you share that, we may might can help you. But, There is no direct way. Let's see how work around.

Can we have macro for that / Simple right click (Send to Excel)? Can you confirm me on this

[suvechha_b]

Thanks for you help.

But my requirement was not fulfilling. As we need to export the report in excel in one document. But here it can be export but with two different excel.

[Anil_Babu_Samineni]

That is the reason. I want to know does user / Client accept to allow the Macros. If so, I can try for that as well once i get free.

So, here i have 2 objects in that i can make single object in Excel by using hit the button after writing Macros. If User / Client allowed i may might try with the easy way. good to hear moving forward