Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am facing a problem that is very accurately described this this post.
http://community.qlik.com/ideas/1722
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.
Thanks
Raghu
Hi,
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.
Thanks
Raghu
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.
-Rob
http:robwunderlich.com
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
CONCATENATE
LOAD null() as Dim1,
null() as Dim2
......null() as Dim7
AUTOGENERATE 1;
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.
Thanks
Raghu
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?
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
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' ) ) ) )
Best,
Tim
.
This worked for me, thanks!
This worked for me, but here issue is it not drill to next level
i have 4 fields
field1
field2
field3
field4
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' ) ) ) )