Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Drill Down Group Behavior not correct

Hi All,

I am facing a problem that is very accurately described this this post.


However, I do not find any solutions to it. How can I stop the automatic drill to the next to next level, if there is only one selectable value in the next level?

Please help. Ideally even if there is only one selectable value, QlikView should show that to maintain the consistency of going down one level at a time. But this does not happen.



13 Replies
Not applicable


The correct URL is community.qlik.com/ideas/1722. Just do not use the http:// thing before the URL. For some reason it does not work.



MVP & Luminary
MVP & Luminary

The workaround I use for this is to add a null() to each level that may have only value. The null won't appear in the chart, but will qualify as two values and thus suppress the drill for one value. See attached example.



Not applicable

Hi Rob,

I tried this solution. I actuall have around 50 fields in my QVD. I am loading this QVD in QVW. Then I am doing a concatenate like this


LOAD null() as Dim1,

null() as Dim2

......null() as Dim7


But does not seem to work in my case. Is there any specific setting required on the table? I am still skipping the dimensions during drilldown.



Not applicable

Hi Rob,

As your solution are most trustworthy than others hence, i am giving you trouble. I have similar requirement where in I have Drill Down group with single possble value. Attached herewith is the QV document.

I have hierarchy G1 which have few calculated dimensions value. The issue is ,it jumps to next level is possible count is 1 . I tried to add null values but calculated dimension fields are not seemed to work for me.

Could you please help me getting the solution?

Not applicable

Hi Rob,

Thanks for all the useful info you get for us in your blog.

Can you please help me on this?

Please refer my post http://community.qlik.com/message/447114#447114

Have a look at Drilldownissue.qvw in the above link...

After going through the link you have provided, I was trying to implement....

Please refer the attached file...Once I select the entity_name am seeing the prd_desc the second level of values where as it not rolling up to the first level even after using the NULL value.

Please also email me praveenkumar.palle@nttdata.com

Thnaks & Regards,

Praveen Palle


Hi Raghu,

were you able to resolve this issue

Please let me know, it will be of great help

Not applicable

Hi All,

I was a little confused with adding NULL values.

If I doesn't select anything it works.
But when I was selecting any value from my drill down group, the result was still wrong. The reason for that is quite simple, if i add null-values to my data model without any connection to the rest of my data model they won't be longer selectable in the associative way.

So i builded an app which should work fine. You need to add all your fields in the normal Way, but the last one with an Ad-Hock variable. Just replace my Fieldname with yours or see attached File.

=$(=IF(GetPossibleCount(Feld3)=GetSelectedCount(Feld3),'Feld4',  IF(GetPossibleCount(Feld2)=GetSelectedCount(Feld2),'Feld3',    IF(GetPossibleCount(Feld1)=GetSelectedCount(Feld1),'Feld2',    'Feld1'    )  )  ) )



Not applicable

This worked for me, thanks!


This worked for me, but here issue is it not drill to next level

i have 4 fields





field3 has only one record its showing as expected in drill from field2 - field3

issue is when click on field3  field4 is not showing its stuck in field3 only

how can i resove this @Tim Loroff

i have written same like this for last field(field4)

=$(=IF(GetPossibleCount(Feld3)=GetSelectedCount(Feld3),'Feld4',  IF(GetPossibleCount(Feld2)=GetSelectedCount(Feld2),'Feld3',    IF(GetPossibleCount(Feld1)=GetSelectedCount(Feld1),'Feld2',    'Feld1'    )  )  ) )