Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ahmad_shawahna
New Contributor

Drill Down Second Level Issue

I have implemented drill-down to show the percentage of mobile voice users as the following:

Measure:

Count({$<[Use of Mobile Voice Service]={"Yes"}>} [Use of Mobile Voice Service])

/

Count([Use of Mobile Voice Service])


Dimension:

Level 1: Year

Level 2: Operator


The problem that the second level of drill-down is using only those "Yeses" which makes the above calculation is 100% for all operators.

1 Solution

Accepted Solutions
Digvijay_Singh
Honored Contributor III

Re: Drill Down Second Level Issue

Your expression work correctly in attached sample, may be your data is generating 100% results.

3 Replies
ahmad_shawahna
New Contributor

Re: Drill Down Second Level Issue

Can anyone provide a help in this regard ?

The results should be different and less than 100% for the operators in the second level.

Digvijay_Singh
Honored Contributor III

Re: Drill Down Second Level Issue

Looks weird, I think the same measure should be execute for next level, is it possible for you to share sample app to look further on how did you define your drill down dimension.

Digvijay_Singh
Honored Contributor III

Re: Drill Down Second Level Issue

Your expression work correctly in attached sample, may be your data is generating 100% results.