How to make my table able to drill in ?

[paulyeo11]

Hi All

I have 2 Table , this 2 table are came from 1 table.

My question is how to combine these 2 table into 1 table ?

Because when user click on cust_id_de = A10077 , i need to display the detail the out standing information.

Hope some one can advise me.

Paul

[paulyeo11]

My QVW

[kaushiknsolanki · Accepted solution]

Hi,

It is not possible to have both information in one table due to the Different Granularity,

But with some arraignment you can show effect like drill down.

Have a look at the application.

Regards,

Kaushik Solanki

[paulyeo11]

Hi Kau

May I know how you do it ? what I want is as your file attachment. But can I make it allow user click on company_de name and it will zoom to table 2 ?

[kaushiknsolanki]

Hi,

You can see the property of both chart, I have used the condition to Hide and Show chart based on the selection.

The logic used is, If the Selected Customer code is 1 then show one chart and hide other.

You can change the Code field with Name field and use it.

Regards,

Kaushik Solanki

[paulyeo11]

Hi Kau

Thank you very much , in QS , How to make it work like QV ? any idea ?

[kaushiknsolanki]

In QS we dont have Show and Hide functionality Yet.

Regards,

Kaushik Solanki

[paulyeo11]

Thank you very much

[paulyeo11]

Hi Kau

Today i try to apply the hide table on my actual app , i am unable to make it work.

Drill in by click on cust_id For hide main table and display sub table.

above is the link which i post the question.

Paul