1 Reply Latest reply: Mar 6, 2018 8:03 AM by Jörg Wünstel RSS

    Problem with calculated Dimension - combined Filtering ??

    Jörg Wünstel

      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.