Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please find below data
In fact I was writing a condition like if(isnull(Vendor_Name), Item) but came to know that for eg 301130B
it should not show up as 301130B has other vendors.
The only output I should get is
105585, 301110 as they are not part of another Vendor
Attaching excel of the same
Or without an advanced search:
=Concat({<Item = e({<Vendor_Name = {"*"} >} ) >} DISTINCT Item,', ')
Show all Items that are excluded by selecting all Vendor names.
Is this be needed to be include in Quotes sunny
{<Item = {"=Len(Trim(Concat(DISTINCT Vendor_Name))) = 0"}>}
Hahahah yes, forgot to add the double quotes
Updated
Sorry Stefan, I didnt get your point here
Can you elaborate this
I was just suggesting an alternative approach using the e() function in set analysis:
Set modifiers with implicit field value definitions ‒ QlikView
The expression should return the two items you are looking for:
105585, 301110
... and I think this is the most efficient approach from performance point of view!
Sorry all a small correction , the report is actually Components with no Vendors
I just changed the expression to
Sum({<Component = {"=Len(Trim(Concat(DISTINCT SOURCE_VENDOR_NAME))) = 0"}>}SHIPPED_AMOUNT_USD)
My Dimension are
Item, Component , Component Description
but some how both the expressions are not working and they are giving the Vendors which have components
Would you be able to share an example where it isn't working?
Sunny's suggestion
Yours
{<Item = {"=Len(Trim(Concat({<Item = e({<Vendor_Name = {"*"} >} ) >} DISTINCT Item,', '))) = 0"}>}
is this what your are suggesting Stefan
