Return quantities based on text in product description

[SteveBorwell]

Hi

So I have my 2 tables joined without issue and have created my pivot table with dimensions and measures. So I want to limit the data loaded from the tables in the script to just include quantities received or picked where the product description contains FSC.

I have tried a variety of solutions that are similar to what I require but all that seems to happen is data fails to load from one of the tables.

Any help appreciated.

[Ksrinivasan · Accepted solution]

hi,

My dummy data:

Gun data:

result:

here only 5 line items were loaded, *FSC* among  8lineitems

ksrinivasan

[SteveBorwell]

Hi 

Thanks for your help that works a treat. In my very early stages of QlikSense learning so that has helped so much. Thanks again for your patience.