topic Re: GetCurrentField() function in Drill Down in QlikView https://community.qlik.com/t5/QlikView/GetCurrentField-function-in-Drill-Down/m-p/86317#M14149 <HTML><HEAD></HEAD><BODY><P>Hi Adil,</P><P></P><P><SPAN style="font-family: 'courier new', courier;">GetPossibleCount($(=GetCurrentField(<SPAN style="color: #3d3d3d; font-size: 13.3333px;">Grp1</SPAN>)))</SPAN></P></BODY></HTML> Sun, 02 Sep 2018 18:14:56 GMT tamilarasu 2018-09-02T18:14:56Z GetCurrentField() function in Drill Down https://community.qlik.com/t5/QlikView/GetCurrentField-function-in-Drill-Down/m-p/86316#M14148 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I am having two functions</P><P></P><P>GetCurrentField(Grp1)&nbsp; - This gives value as 'subcountry'</P><P><SPAN style="font-size: 13.3333px;">GetPossibleCount</SPAN>(subcountry) - <SPAN style="font-size: 13.3333px;">This gives value as '35'</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">However when i write GetPossibleCount(GetCurrentField(Grp1)) I do not get any value. Please provide your valuable suggestions.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Regards</SPAN></P><P><SPAN style="font-size: 13.3333px;">Adil</SPAN></P></BODY></HTML> Sun, 02 Sep 2018 16:11:31 GMT https://community.qlik.com/t5/QlikView/GetCurrentField-function-in-Drill-Down/m-p/86316#M14148 Adil-Haider 2018-09-02T16:11:31Z Re: GetCurrentField() function in Drill Down https://community.qlik.com/t5/QlikView/GetCurrentField-function-in-Drill-Down/m-p/86317#M14149 <HTML><HEAD></HEAD><BODY><P>Hi Adil,</P><P></P><P><SPAN style="font-family: 'courier new', courier;">GetPossibleCount($(=GetCurrentField(<SPAN style="color: #3d3d3d; font-size: 13.3333px;">Grp1</SPAN>)))</SPAN></P></BODY></HTML> Sun, 02 Sep 2018 18:14:56 GMT https://community.qlik.com/t5/QlikView/GetCurrentField-function-in-Drill-Down/m-p/86317#M14149 tamilarasu 2018-09-02T18:14:56Z Re: GetCurrentField() function in Drill Down https://community.qlik.com/t5/QlikView/GetCurrentField-function-in-Drill-Down/m-p/86318#M14150 <HTML><HEAD></HEAD><BODY><P>Hi Tamil,</P><P></P><P>Thanks for your response and time.</P><P></P><P>If you can explain the reason that would be of great help.</P><P></P><P>Regards</P><P>Adil</P></BODY></HTML> Sun, 02 Sep 2018 18:24:28 GMT https://community.qlik.com/t5/QlikView/GetCurrentField-function-in-Drill-Down/m-p/86318#M14150 Adil-Haider 2018-09-02T18:24:28Z Re: GetCurrentField() function in Drill Down https://community.qlik.com/t5/QlikView/GetCurrentField-function-in-Drill-Down/m-p/86319#M14151 <HTML><HEAD></HEAD><BODY><P>Hi Adil,</P><P></P><P>You are welcome. I believe "GetCurrentField" function is not evaluated inside the "GetPossibleCount" function. So we are using dollar sign expansion to evaluate "GetCurrentField" and using the result as a field name inside the "GetPossibleCount" Function.</P><P></P><P>I just put these expressions in a straight table to understand this better.</P><P></P><P><IMG __jive_id="212424" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/212424_Capture.PNG" style="height: 98px; width: 620px;" /></P><P></P><P><IMG __jive_id="212425" alt="Capture2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/212425_Capture2.PNG" style="height: auto;" /></P></BODY></HTML> Sun, 02 Sep 2018 18:41:19 GMT https://community.qlik.com/t5/QlikView/GetCurrentField-function-in-Drill-Down/m-p/86319#M14151 tamilarasu 2018-09-02T18:41:19Z Re: GetCurrentField() function in Drill Down https://community.qlik.com/t5/QlikView/GetCurrentField-function-in-Drill-Down/m-p/86320#M14152 <HTML><HEAD></HEAD><BODY><P>ok thanks!</P></BODY></HTML> Sun, 02 Sep 2018 18:45:32 GMT https://community.qlik.com/t5/QlikView/GetCurrentField-function-in-Drill-Down/m-p/86320#M14152 Adil-Haider 2018-09-02T18:45:32Z