topic Re: Calculated Dimension in drill-down not selecting in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension-in-drill-down-not-selecting/m-p/1344845#M821272 <HTML><HEAD></HEAD><BODY><P>Hope the attached file helps</P></BODY></HTML> Thu, 03 Aug 2017 15:23:46 GMT krishnacbe 2017-08-03T15:23:46Z Calculated Dimension in drill-down not selecting https://community.qlik.com/t5/QlikView/Calculated-Dimension-in-drill-down-not-selecting/m-p/1344843#M821270 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi everyone,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I am having an issue with calculated dimensions in a drill-down. I created a really basic example I'm attaching. </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">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. </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">However, if I click the 14 for 'nope', nothing changes and I can't see the exact 14 IDs that represent 'nope'.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I'm using a conditional statement for the caculated dimension.</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; " =if(score1 = 100 and score2 = 100 and score3 = 100, 'top', 'nope') "</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Why does this happen? How can I circumvent it? Any help would be greatly appreciated!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-in-drill-down-not-selecting/m-p/1344843#M821270 Anonymous 2020-11-25T16:16:04Z Re: Calculated Dimension in drill-down not selecting https://community.qlik.com/t5/QlikView/Calculated-Dimension-in-drill-down-not-selecting/m-p/1344844#M821271 <HTML><HEAD></HEAD><BODY><P>Try attached</P></BODY></HTML> Thu, 03 Aug 2017 15:17:49 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-in-drill-down-not-selecting/m-p/1344844#M821271 sunny_talwar 2017-08-03T15:17:49Z Re: Calculated Dimension in drill-down not selecting https://community.qlik.com/t5/QlikView/Calculated-Dimension-in-drill-down-not-selecting/m-p/1344845#M821272 <HTML><HEAD></HEAD><BODY><P>Hope the attached file helps</P></BODY></HTML> Thu, 03 Aug 2017 15:23:46 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-in-drill-down-not-selecting/m-p/1344845#M821272 krishnacbe 2017-08-03T15:23:46Z