Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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

View solution in original post

3 Replies
Anonymous
Not applicable
Author

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

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

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