Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
Showing results for 
Search instead for 
Did you mean: 

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


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

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