topic Re: drill down option in QlikView

drill down option

ssriramin19 — Wed, 08 Jul 2015 06:36:55 GMT

There is a requirement in which only certain field needs drill functionality to appear. For rest other drill should not be made.

Please find the attached document which has the sample lay out report .

In the attached report the drill needs to be applied only for the field DP (which is marked as DP+ in the report) . Once DP+ is drilled , next level goes to PC1 , sales number . which is shown in the chart layout.

Please explain how to achieve the above scenario?

Thanks

Sriram

Re: drill down option

datanibbler — Wed, 08 Jul 2015 06:56:53 GMT

Hi sriram,

the Drilldown option is to be applied to that chart, right? Is it a straight_table chart?

Well, I usually do without Drilldown - the effect is the same, I just go another way:

- You have one field as dimension to that chart, right?

- Apply a condition to that dimension (like > Getselectedcount([dimension]) = 0 < - meaning that the
dimension is active as long as the user has not selected any value on that dimension_field.

- Then add a second dimension with whatever is the next level below > DP < and
    apply a condition like > Getfieldselections([dimension]) = 'DP' to that
   => So that second dimension will become active when the user has selected 'DP', not any other value, and
        at the same time the first dimension will become inactive.

Would that about match your requirement?

Best regards,

DataNibbler

Re: drill down option

ssriramin19 — Wed, 08 Jul 2015 07:36:20 GMT

I am not more clear on that. I did tried the approach suggessted by you but unable to figure it out what went wrong .

Can you share me with an example.

Thanks

Sriram

Re: drill down option

datanibbler — Wed, 08 Jul 2015 07:39:24 GMT

Hi,

I will try to put together a small sample and post it, along with the Excel file containing the base_data.

Re: drill down option

ssriramin19 — Wed, 08 Jul 2015 07:42:54 GMT

That would be really helpful . so I can understand better.

Re: drill down option

datanibbler — Wed, 08 Jul 2015 07:49:59 GMT

There you go.

This small example illustrates what I mean with the two dimensions - I hope that matches what you want to do.

Have a look.

Best regards,

DataNibbler

Re: drill down option

ssriramin19 — Wed, 08 Jul 2015 08:07:35 GMT

few clarifications with respect to example now ,

a)team 1 to team 4 is related only to dept D right ? its not for any other field .

b)if any other dept is chosen then the sales value not appear in the chart .It is blank . why it is so ?

c)also you have used only get selected count in the text box. whether it should be used only there ?

d)you have mentioned getfeildselection(dimension) in the above explanation , but not used anywhere in the sample report .How to incorporate that ?

The sample report created by you is certainly closed to my requirement but please explain on the above things

Thanks

Sriram

Re: drill down option

ssriramin19 — Wed, 08 Jul 2015 08:36:56 GMT

can you please explain me on the above mentioned questions

Re: drill down option

datanibbler — Wed, 08 Jul 2015 08:51:39 GMT

Hi,

1) yes, you are right - the four teams belong to Dpt_D in my example. That is the drilldown possibility.

2) I don't know why the value isn't shown with any other selection - it is in the chart in my sample_app => maybe
you can share your qvw so we can have a closer look at your issue?

3) The text_boxes are just for further illustration, they are not essential to the functioning of the chart;

4) The function is certainly used in the chart. Look on the "dimension" tab of the dialog, in the edit_field "condition".

Best regards,

DataNibbler

Re: drill down option

ssriramin19 — Wed, 08 Jul 2015 09:46:17 GMT

Now I can able to understand the logic. Can you please explain me how this approach needs to be implemented in the qlikview version 9.Currently we are using version 9 for our development of reports.

I did gone through your requirement in qlikview 11 version . It is proper .

Please do the needful on this .Is it possbile to implement in qlikview 9 version .

Thanks

Sriram

Re: drill down option

datanibbler — Wed, 08 Jul 2015 10:09:28 GMT

Hi,

that I honestly don't know. I have been working with newer versions for a long time now and I don't have different verysions here to try out what is possible.

Maybe someone else can help you on here?

Re: drill down option

ssriramin19 — Wed, 08 Jul 2015 10:14:02 GMT

Can you ask some one and let me know on the approach to be adopted.

I asked quite a few people here but no one has proper idea on how to go about it .

Since this very important report to be developed it would be better if you can guide me on this

Thanks

Sriram