How to remove the filter from only one dimension column?

[#1]

Hi All,

I'm wondering if someone can help me with following case:

I would like to select 'Supplier' in my report and get a list of 'Items' provided by selected Supplier and in the same time seeing which other Suppliers are providing these items - which formula sholud I use?

I tried with: =sum({<Supplier=>}OrderedSpend  in expression, but shows me all items at the end.

Thank you in advance for your help!

[Anil_Babu_Samineni]

I didn't understand what are you trying over here, But you could use $ identifies with in the flower and angular bracket like {$< ....>}

[sunny_talwar]

May be like this

=Sum({<Supplier=, Item = p(Item)>}OrderedSpend)

[#4]

Thank you Sunny, it's exactly what I was looking for!

[sunny_talwar]

Awesome, please close the thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny