I created a OLAP Table, with “Material Number” as a Dimension and “Average(Delivery Reliability)” as a KPI. Then I filter/select the Deliveries, that have to be sent out in the next days.
In my first table, I would like to have the Materials filtered but only the KPI “Average(Delivery Reliability)” to “ignore” this selection. Is this somehow possible?
My goal is to show the historic Delivery Reliability for the Materials that will be sent out in the next few days. Currently I either get all the Materials with the right KPI, or the filtered Materials with the wrong KPI.
In Qlik Sense you can do that with “Set analysis”. (defining a set (or group) of data values that is different from the normal set defined by the current selections)
Thank you very much