Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
paulyeo11
Not applicable

How to make my table able to drill in ?

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

1 Solution

Accepted Solutions
kaushik_solanki
Not applicable

Re: How to make my table able to drill in ?

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

8 Replies
paulyeo11
Not applicable

Re: How to make my table able to drill in ?

My QVW

kaushik_solanki
Not applicable

Re: How to make my table able to drill in ?

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
Not applicable

Re: How to make my table able to drill in ?

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 ?

kaushik_solanki
Not applicable

Re: How to make my table able to drill in ?

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
Not applicable

Re: How to make my table able to drill in ?

Hi Kau

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

kaushik_solanki
Not applicable

Re: How to make my table able to drill in ?

In QS we dont have Show and Hide functionality Yet.

Regards,

Kaushik Solanki

paulyeo11
Not applicable

Re: How to make my table able to drill in ?

Thank you very much

paulyeo11
Not applicable

Re: How to make my table able to drill in ?

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