topic Re: How to remove the filter from only one dimension column? in QlikView

How to remove the filter from only one dimension column?

Wed, 28 Jun 2017 09:49:04 GMT

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!

Re: How to remove the filter from only one dimension column?

Anil_Babu_Samineni — Wed, 28 Jun 2017 15:38:11 GMT

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

Re: How to remove the filter from only one dimension column?

sunny_talwar — Wed, 28 Jun 2017 16:11:13 GMT

May be like this

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

Re: How to remove the filter from only one dimension column?

Thu, 29 Jun 2017 07:23:57 GMT

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

Re: How to remove the filter from only one dimension column?

sunny_talwar — Thu, 29 Jun 2017 16:31:36 GMT

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

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny