topic Re: Drill down in list box issue in QlikView

Drill down in list box issue

shyamcharan — Sat, 12 Jul 2014 11:18:02 GMT

Hi,

I am stuck with an issue where I am trying to create a list box with numerical, text and mixed value fields

When i try to drill down it drills down but it is in appropriate.

I have Fields with below values:

A B C D

ABC 74 ART 4 XYZ

Now when i try to drill from A to B i directly get skipped to D not to a B and then C. I thought it is with the combination of the values of the string and the numerical values that is causing the problem but i think i am wrong.

Need expert advice plaase help.

Re: Drill down in list box issue

ashfaq_haseeb — Sun, 13 Jul 2014 09:42:12 GMT

Hi,

This is how the drill down works,

If you have more then one values for B it will show B or else it will drill to lowest grain.

This is what happened in your case.

Regards

ASHFAQ

Re: Drill down in list box issue

shyamcharan — Sun, 13 Jul 2014 11:41:21 GMT

Hi Ashfaq,

Thanks for the reply.

But do we have any work around for this?

Not always the data will have more than one related value I believe. Please suggest.

Regards,

Shyam

Re: Drill down in list box issue

ashfaq_haseeb — Sun, 13 Jul 2014 11:45:19 GMT

Hi,

This is how it works. No other solution or workaround available.

Regards

ASHFAQ

Re: Drill down in list box issue

shyamcharan — Sun, 13 Jul 2014 11:49:19 GMT

Thanks Ashfaq.

I have observed one more behavior. When I try drill down from level 3, it does not got to level 4.

Level 4 is that last one. In this case it is D and when i try drilling down to D from C it does not go.

Any suggestions?

Regards,

Shyam.

Re: Drill down in list box issue

ashfaq_haseeb — Sun, 13 Jul 2014 11:55:20 GMT

Hi,

may be you don't have data of level 4 for the selection you made.

Monitor the same with current selection box.

Can you share a sample app to look in.

Regards

ASHFAQ

Re: Drill down in list box issue

ashfaq_haseeb — Sun, 13 Jul 2014 12:03:08 GMT

Hi Shyam,

Can you mark appropriate answer.

Regards

ASHFAQ

Re: Re: Drill down in list box issue

shyamcharan — Sun, 13 Jul 2014 12:16:14 GMT

Hi Ashfaq,

Please find the attached file.

Re: Re: Re: Drill down in list box issue

ashfaq_haseeb — Sun, 13 Jul 2014 12:25:39 GMT

Hi,

Look at the attached application.

As I say there is no possible value in L4 that's why you can't drill to L4.

Regards

ASHFAQ

Re: Re: Re: Drill down in list box issue

shyamcharan — Sun, 13 Jul 2014 12:31:16 GMT

Okay Thank you.

I hope i marked the answers correct. Please let me know if I am supposed to do anything else.