Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I didn't understand what are you trying over here, But you could use $ identifies with in the flower and angular bracket like {$< ....>}
May be like this
=Sum({<Supplier=, Item = p(Item)>}OrderedSpend)
Thank you Sunny, it's exactly what I was looking for!
Awesome, please close the thread by marking correct and helpful responses.
Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny