filter issue

[emilyrabbit]

Hi ,I create a master item,

[Company Name]=IF(Match(Fact_Type,'FACT_ORDER','FACT_INVOICE','FACT_PURCHASE_ORDER','FACT_OUTBOUND_DELIVERY'),
[Company Sold To Party],
[Company]
)

And I create a sheet , [Company Name],[Company Sold To Party],[Company]

when I select [Company Name]= A, and the [Company Sold To Party]and [Company] are selected at the same time .It isn't what I want to. Pls help me .

[chriscammers · Accepted solution]

You are going to have to move your formula to the data model. When you use a complex formula in a calculated dimension qlik interprets the selection values based on the formula so whatever fields contribute to the value end up with the selections on them.