Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
gerrycastellino
Contributor III

Alternate state, aggr function for intersection of 2 dimensions

I have a dimension asset_class,  that I want to change based on the intersection of 2 other dimensions that are in alternate state(s)

A, B.

How do I structure my asset_class expression to list this intersection ?

I'm trying something like the below, but need help ....

=aggr(only({A*B} ASSET_CLASS), ASSET_CLASS)

Is the aggr function to only way to achieve this ?

Gerry.

Tags (1)
1 Reply
gerrycastellino
Contributor III

Re: Alternate state, aggr function for intersection of 2 dimensions

ok, this seems to be working,  I need to test further:

=aggr(only({<ASSET_CLASS=P({A}) * P({B})>} ASSET_CLASS), ASSET_CLASS)

Community Browser