Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
gerrycastellino
Creator III
Creator III

Question on aggr/if in alternate state

=if(not(isnull(only({[s_Hier_Comp2]} fieldA))),

aggr(only({<ASSET_CLASS=P({s_Hier_Comp1}) * P({s_Hier_Comp2})>} ASSET_CLASS), ASSET_CLASS),

aggr(only({<ASSET_CLASS=P({s_Hier_Comp3}) * P({s_Hier_Comp4})>} ASSET_CLASS), ASSET_CLASS)

)

I have the above statement in an expression for a list box.

I need to apply a union of 2 alternate(s)  based on my if condition (if there is a value for fieldA.

There seems to be some syntax issues in this, need to re-structure my aggr/if

Gerry

10 Replies
gerrycastellino
Creator III
Creator III
Author

only one selection possible.