topic Expression in Multibox? in QlikView

Expression in Multibox?

Wed, 06 Nov 2013 15:07:42 GMT

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

Re: Expression in Multibox?

Wed, 06 Nov 2013 15:13:21 GMT

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

Re: Expression in Multibox?

swuehl — Wed, 06 Nov 2013 15:16:48 GMT

What expression are you using?

Re: Expression in Multibox?

Wed, 06 Nov 2013 15:20:52 GMT

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

Re: Expression in Multibox?

Wed, 06 Nov 2013 15:22:51 GMT

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

Re: Expression in Multibox?

swuehl — Wed, 06 Nov 2013 15:24:44 GMT

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.

Re: Expression in Multibox?

Wed, 06 Nov 2013 15:28:10 GMT

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

Re: Expression in Multibox?

swuehl — Wed, 06 Nov 2013 15:48:06 GMT

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.

Re: Expression in Multibox?

Wed, 06 Nov 2013 15:51:12 GMT

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

Re: Expression in Multibox?

Mina — Mon, 09 Nov 2020 09:43:36 GMT

Hi Dear Swuehl,

I use this solution in Multi Box and it's worked. Now I want it filters just most expressions and other expression ignore this selection. but i don't know how write this condition in my expressions.

I write this Expression in Multi box .(Calculate Consumer Price )

=aggr(sum({<DemandStatus=>}Total_Price_Consumer)/sum({<DemandStatus=>}Qty_Inventory),
DELIVERYPLANT,Part_Code,Batch_Number)

now i want when one price selected , Onhand inventory Expression change and Atp inventory Expression dose not change.

Do you know any ways that helps me?

Thank you

Mina

Re: Expression in Multibox?

Mina — Tue, 10 Nov 2020 12:29:19 GMT

Hi ,I have a Problem with Multi Box.

I use Expression in Multi Box and it's work. Now I want Some expression ignore this selection. but i don't know how write this condition in my expressions.

I write this Expression in Multi box .(Calculate Consumer Price )

=Aggr(sum(Total_Price_Consumer)/sum(Qty_Inventory),
filed1,filed2,filed3)

Now i want when one price is selected , Expression1 change and Expression2 (in Other Chart) dose not change.

Do you know any ways that helps me?

Thank you

Mina