Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to create a nested function that takes some parameters. In my variable overview I created these three functions:
percValue = count( $1)/count($2)
minValue = min($1)
checkFunc =
if( $(percValue($1,$2)) < 0.4 or $(minValue($1)) = 0, 0.4,
if(($(percValue($1,$2))) < 0.8, 0.8, 2))
and then be able to call it from a text object, something like:
=$(checkFunc(my_value1,my_value2))
but for some reasons, this do no work. Any suggestions? What am I doing wrong?
Thanks in advance.
Works for me. But I don't know what data your fields my_value1 and my_value2 contain. Or if they are fields at all. Perhaps you can post a small qlikview document that illustrates the problem.