Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Adil-Haider
Contributor III
Contributor III

GetCurrentField() function in Drill Down

Hi All

I am having two functions

GetCurrentField(Grp1)  - This gives value as 'subcountry'

GetPossibleCount(subcountry) - This gives value as '35'


However when i write GetPossibleCount(GetCurrentField(Grp1)) I do not get any value. Please provide your valuable suggestions.


Regards

Adil

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Hi Adil,

GetPossibleCount($(=GetCurrentField(Grp1)))

View solution in original post

4 Replies
tamilarasu
Champion
Champion

Hi Adil,

GetPossibleCount($(=GetCurrentField(Grp1)))

Adil-Haider
Contributor III
Contributor III
Author

Hi Tamil,

Thanks for your response and time.

If you can explain the reason that would be of great help.

Regards

Adil

tamilarasu
Champion
Champion

Hi Adil,

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.

I just put these expressions in a straight table to understand this better.

Capture.PNG

Capture2.PNG

Adil-Haider
Contributor III
Contributor III
Author

ok thanks!