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

Calculated Dimension in drill-down not selecting

Hi everyone,

I am having an issue with calculated dimensions in a drill-down. I created a really basic example I'm attaching.

In the example, I have 'dim1' 1, 2 and 3, if you click on dim1 you'll get 15 IDs in a stacked bar graph. 1 ID is 'top' and the other 14 are 'nope'. If click the 'top' area of the bar graph, or click the 'top' option in the legend,the graph filters to the 1 ID.

However, if I click the 14 for 'nope', nothing changes and I can't see the exact 14 IDs that represent 'nope'.

I'm using a conditional statement for the caculated dimension.

     " =if(score1 = 100 and score2 = 100 and score3 = 100, 'top', 'nope') "

Why does this happen? How can I circumvent it? Any help would be greatly appreciated!

2 Replies
sunny_talwar

Try attached

krishnacbe
Partner - Specialist III
Partner - Specialist III

Hope the attached file helps