If this is a chart expression it probably does not work because the naked field references* have multiple possible values at each row. In this case QV does not know which value to use and returns null (like the Only() function).
You will need to rewrite the expression to avoid the naked fields.
* A field name not enclosed in an aggregation function (like Sum(), Max(), Avg())
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Can you tell us, your logic with simple words or with example, So that it will become easier to help you
Regards
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
I want, when a level (example: EXECUTION_PLANNING_NAME1 ) has values, and the next level (EXECUTION_PLANNING_NAME2) does not have values, then i want the EXECUTION_PLANNING_NAME1 because ot would be the last node in the tree that has values(i.e: child node)
I want to list all the nodes (EXECUTION_PLANNING_NAME1 in our example) inside a list box
In that case you need little modification in your expression.
try below
if(
count(EXECUTION_PLANNING_NAME1)>0 and IsNull(EXECUTION_PLANNING_NAME2),
EXECUTION_PLANNING_NAME1,EXECUTION_PLANNING_NAME2
)
Regards
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
The above still gives an error (it's not about which level im inserting). It's the fact that qlikview isnt displaying the values because of what i have read from other posts which is the naked field.
