Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
sekharQV
Contributor

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
MVP
MVP

Re: Drill Down Group not working

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?

Re: Drill Down Group not working

sekharQV
Contributor

Re: Drill Down Group not working

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

MVP
MVP

Re: Drill Down Group not working

Looks like stalwar1's answer would help.