Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Expression in Multibox?

Hello All,

I am trying to use an expression in place of a dimension in a multibox, but for some reason qlikview won't let me do it. The newly created multibox with the expression appears inactive and no data is displayed. The expression worked for different charts.

Thank you,

Anna

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

In a list box field expression, you can only use an aggregation function in combination with advanced aggregation,

=aggr( sum({<Metrics={[Percentage NOT NULL]}>}[Data Targets])  , DIMENSIONFIELD1, DIMENSIONFIELD2, ...)


because you need to create an output that is 1-dimensional, not only a scalar.

View solution in original post

8 Replies
Highlighted
Not applicable

May be silly but check Expression in List box first, it should return values then it should work in Multibox also.

Highlighted
MVP
MVP

What expression are you using?

Highlighted
Not applicable

sum({<Metrics={[Percentage NOT NULL]}>}[Data Targets])

Highlighted
Not applicable

It works in the list box, but multibox is still stubborn

Highlighted
MVP
MVP

In a list box field expression, you can only use an aggregation function in combination with advanced aggregation,

=aggr( sum({<Metrics={[Percentage NOT NULL]}>}[Data Targets])  , DIMENSIONFIELD1, DIMENSIONFIELD2, ...)


because you need to create an output that is 1-dimensional, not only a scalar.

View solution in original post

Highlighted
Not applicable

did you mean in a multibox? Because listbox is not a problem

Highlighted
MVP
MVP

Well you said 'I am trying to use an expression in place of a dimension' so I have assumed you are using a field expression (e.g. in a list box) on general tab, not an expression on expression tab.

Highlighted
Not applicable

I meant in the multibox, but the aggr expression provided works! Thank you!