Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

joerg_wuenstel
New Contributor

Problem with calculated Dimension - combined Filtering ??

Dear all,

i have a Problem with some calculated dimension.

I use follwing fomula to set up three special dimension which should be used at a table analysis.

Sum open  Orders by Item

=Aggr(Sum([Openorders.Quantity]),ItemNo)

Sum open Purchase Orders by item

=if(isnull(Aggr(Sum({$<[Purchaseorder Positions.Status] ={0}>} [Purchaseorder Positions.Quantity]), ItemNo)),'0',Aggr(Sum({$<[Purchaseorder Positions.Status] ={0}>} [Purchaseorder Positions.Quantity]), ItemNo))

Last Date of Intake by item

=date(Aggr(max([Intake Positions.Date.autoCalendar.Date]),ItemNo), 'DD.MM.YY')

All Dimensons are working well.

My Problem is that intention was that i thoutght tha i could combine  each dimension with filtering.

But all filter would be allocated to the Dimension ItemNo

Is there any solution to solve such a problem at the Qlik Sense Frontend?

I hope anyone understand my issue.

Thank you.

1 Reply
joerg_wuenstel
New Contributor

Re: Problem with calculated Dimension - combined Filtering ??

One Example.

I chosed OpenOrders = 0 to filter all items wiht no open order.

This filter would applied to itemNo und choose 392 from 136440 items.

I expected that i could see filtering of OpenOrders instead of ItemNo

Community Browser