topic Re: Drill Down in QlikView

Drill Down

rathnam_qv — Tue, 25 Mar 2014 09:26:44 GMT

Hi all,

i have straight table...with one dimension

when i select a field value from that dimension...it should drill down to other report.

how to do that...can u please tel me.

Regards,

rathnam.

Re: Drill Down

jsingh71 — Tue, 25 Mar 2014 09:29:43 GMT

Can you explain little bit more about your requirement.

Re: Drill Down

kiranmanoharrode — Tue, 25 Mar 2014 09:31:30 GMT

Please post sample application for detailed understanding

Re: Drill Down

MarcoWedel — Tue, 25 Mar 2014 09:41:37 GMT

If you need only one Dimension, then you cannot drill down.

Drill down means going to a deeper, more detailed dimension.

What do you mean by "other report"?

Re: Drill Down

rathnam_qv — Tue, 25 Mar 2014 09:44:30 GMT

thanks for your reply.

But my requirement is...if i select one values from the straight table..another chart should get populate.

Re: Drill Down

sudeepkm — Tue, 25 Mar 2014 09:49:02 GMT

Do you want to show another chart based on the selection of a Field's value in a Straight table?

In that case you can have the chart's layout being conditionally displayed.

show condition:

getSelectedCount(YourField)>0

whenever the selected count of the Field in the straight table is more than zero then the second Chart will show up.

Re: Drill Down

rathnam_qv — Tue, 25 Mar 2014 10:06:20 GMT

ya i did that..because of this the straight table is disappearing.

my requirement is to...when i select a field's value in the straight table...the other chart should get populate..

how to connect the other chart with the straight table.

Re: Drill Down

MarcoWedel — Tue, 25 Mar 2014 12:10:15 GMT

you don't need a special connection between your chart and the table, if you do like Sudeep Mahapatra suggested.

The selection in the table selects field values. The show condition then turns the chart on or off.

regards

Marco

Re: Drill Down

jsingh71 — Tue, 25 Mar 2014 12:18:40 GMT

Hi,

Find Attachment. If your requirement is different then let me know.

--Jai

Re: Drill Down

Tue, 25 Mar 2014 12:26:36 GMT

Check the attached one

Re: Drill Down

Tue, 25 Mar 2014 12:35:16 GMT

Hi,

you can have all your reports in different tabs and tab names in one flat table. On selection a single value use activate sheet action or use a variable which will have the selected tab name and use that as a opening condition for the tab.

Regards,

Abhishek