Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sekharQV
Creator
Creator

Drill Down Group not working

Hi Techies,

I have below requirement  regarding Drill down Group.

I have 4 dimensions as shown in below table.

AreaCompanyRegionBranch
R01Atum(00470)BergenBergen
R01Atum(00470)BodoBodo
R01Atum(00470)HamerHamer
R01Atum(00470)HarstadHarstad
R01Atum(00470)LarvikLarvik
R01Atum(00470)MossMoss
R01Atum(00470)OsloOslo
R01Atum(00470)StarangerStaranger

The expression is: sum({<[CATEGORYCODE]={'TR'}>[Amount]})

---> Area and Company has only one value

---> Region and Branch has similar values

I tried to create a drill down group on bar chart with the order as Area,Company,Region,Branch.

But the chart is showing Region at first level and next Branch. I am unable to display Are and Company.

Can anybody help me regarding this issue?

Thanks,

Rajasekhar

4 Replies
johnw
Champion III
Champion III

As I recall, this is simply QlikView behavior. If there is only a single value for one of the fields in the drill down, it drills down further. What information is there to be gained, after all, by looking at the exact same number again? To actually drill down usefully, it has to take you to where there are multiple values again.

It seems you want to make the users go through additional clicks to get to the same information. What would be the purpose of that?

sekharQV
Creator
Creator
Author

Hi John,

Thanks for reply.

I agree with what you saying.  But the requirement is to drill down from Area-->Company-->Region-->Branch.

In the future the different values will be populated for 'Area' and 'Company. But as of now they are having only one value.

Is there any way to get rid of this issue.?

Thanks,

Rajasekhar

johnw
Champion III
Champion III

Looks like stalwar1's answer would help.