topic Re: drill down dimension in QlikView https://community.qlik.com/t5/QlikView/drill-down-dimension/m-p/1166709#M379749 <HTML><HEAD></HEAD><BODY><P>Please sugegst something , its kind of little urgent..</P></BODY></HTML> Thu, 08 Sep 2016 16:01:10 GMT yogitamehta10 2016-09-08T16:01:10Z drill down dimension https://community.qlik.com/t5/QlikView/drill-down-dimension/m-p/1166706#M379746 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P></P><P> Could you Plaese help me in resolving this issue , i'm using qliskense, i have a drill down dimesion </P><P></P><P></P><P>first dimension:status two values - Accepted, Rejected</P><P></P><P></P><P>second dimension : failure occurance</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">calculate dimension i'm using </SPAN></P><P>If(IsNull(FAILURE_OCCURENCE),'Attempt 1'</P><P>,if(FAILURE_OCCURENCE='1','Attempt 2',if(FAILURE_OCCURENCE='2','Attempt 3',</P><P>if(FAILURE_OCCURENCE='3','Attempt 4',if(FAILURE_OCCURENCE='4','Attempt 5',if(FAILURE_OCCURENCE &gt;'4','Attempt 5+'))))))</P><P></P><P></P><P></P><P></P><P></P><P></P><P>my conecrn is when i qlik on accpeted ,&nbsp; it should show&nbsp; values related of accepted txn for second diemnsion</P><P></P><P></P><P>and when i qlik on rejected&nbsp; it should show values of rejected occurrence , but as of now it is showing total value while clicking on accepted and rejected , both are showing same value.</P><P></P><P></P><P>any workaround for this ?</P></BODY></HTML> Thu, 08 Sep 2016 11:33:32 GMT https://community.qlik.com/t5/QlikView/drill-down-dimension/m-p/1166706#M379746 yogitamehta10 2016-09-08T11:33:32Z Re: drill down dimension https://community.qlik.com/t5/QlikView/drill-down-dimension/m-p/1166707#M379747 <HTML><HEAD></HEAD><BODY><P>Its difficult to diagnose the problem based on the information provided. More information about your data model would greatly assist in providing useful advice.</P></BODY></HTML> Thu, 08 Sep 2016 11:41:28 GMT https://community.qlik.com/t5/QlikView/drill-down-dimension/m-p/1166707#M379747 jonathandienst 2016-09-08T11:41:28Z Re: drill down dimension https://community.qlik.com/t5/QlikView/drill-down-dimension/m-p/1166708#M379748 <HTML><HEAD></HEAD><BODY><P>see i have this table that has two colmuns </P><P></P><P></P><P>status , occur an </P><P></P><P></P><P>values are like this , just a simple&nbsp; table</P><P></P><P></P><P></P><P></P><P></P><P></P><P>STATUS FAILURE_OCCURENCE</P><P>Accepted 1</P><P>Accepted 2</P><P>Accepted 1</P><P>Accepted 1</P><P>Accepted 1</P><P>Accepted 1</P><P>Inactive 1</P><P>Accepted 1</P><P>Inactive 1</P><P>Accepted 2</P><P>Accepted 1</P><P>Accepted 1</P><P>Inactive 1</P><P>Accepted 1</P><P>Accepted 1</P><P>Accepted 1</P><P>Rejected 1</P><P>Accepted 1</P><P>Inactive 1</P><P>Accepted 1</P><P>Accepted 1</P><P>Accepted 1</P><P>Accepted 1</P><P>Accepted 1</P><P>Rejected 2</P><P>Accepted 1</P><P>Rejected 2</P><P>Accepted 1</P><P>Rejected 1</P><P>Accepted 1</P><P>Accepted 1</P><P>Rejected 1</P><P>Accepted 1</P><P>Accepted 2</P><P>Accepted 1</P><P>Accepted 1</P><P>Accepted 1</P><P>Accepted 1</P><P>Inactive 1</P><P>Accepted 1</P><P>Inactive 1</P><P>Accepted 2</P><P>Accepted 1</P><P>Accepted 1</P><P>Inactive 1</P><P>Accepted 1</P><P>Accepted 1</P><P>Accepted 1</P><P>Accepted 1</P><P>Accepted 1</P><P>Rejected 2</P><P>Accepted 1</P><P>Rejected 2</P><P>Rejected 1</P><P>Accepted 1</P><P>Inactive 1</P><P>Accepted 1</P><P>Accepted 1</P><P>Rejected 1</P><P>Accepted 2</P><P></P><P></P><P></P><P></P><P> now i want if in pie chart i qlik on accepted then it will tell me occurance count of&nbsp;&nbsp; accpeted&nbsp; and if i click on rejected then it qill show me the count of rejcted</P></BODY></HTML> Thu, 08 Sep 2016 12:19:52 GMT https://community.qlik.com/t5/QlikView/drill-down-dimension/m-p/1166708#M379748 yogitamehta10 2016-09-08T12:19:52Z Re: drill down dimension https://community.qlik.com/t5/QlikView/drill-down-dimension/m-p/1166709#M379749 <HTML><HEAD></HEAD><BODY><P>Please sugegst something , its kind of little urgent..</P></BODY></HTML> Thu, 08 Sep 2016 16:01:10 GMT https://community.qlik.com/t5/QlikView/drill-down-dimension/m-p/1166709#M379749 yogitamehta10 2016-09-08T16:01:10Z