Create a Flag that reduces QVW to only show products 'Shebo'

[Anonymous]

I have a model that shows specific products

The products are loaded into the script using a Load Inline Statement.

I want to create a Flag in the script that when selected reduces the QVW to a specific product, Shebo.

Here is a sample script:

Groupings:

LOAD * INLINE [

    ProductName, ProductType

    CUSTOM\SheboA112, 1

    CUSTOM\SheboB1123, 1

    CUSTOM\SheboC1124, 2

    CUSTOM\SheboD1125, 2

    CUSTOM\SheboE1126, 3

    CUSTOM\ProlineA1127, 1

    CUSTOM\ProlineB1128, 1

    CUSTOM\ProlineC1129, 2

    CUSTOM\YealinkA11210, 2

    CUSTOM\YealinkB11211, 2

    CUSTOM\YealinkC11212, 3

];

[Gysbert_Wassenaar · Accepted solution]

Add a line to the load statement:

Groupings:

LOAD *,

wildmatch(ProductName, '*Shebo*') as SheboFlag

INLINE [

    ProductName, ProductType

    CUSTOM\SheboA112, 1

    CUSTOM\SheboB1123, 1

...etc..

[khadeer]

=if(WildMatch( SubField(ProductName,'\',2),'Shebo*'),ProductName) as FLAG

PFA.

[Anonymous]

Thanks, works great!

[Anonymous]

Can I use the field SheboFlag in my charts with Set Analysis or something so the charts only show Shebo Products?

Is it possible to do this without making any selections?

[Jason_Michaelides]

Sum({<SheboFlag={1}>} Sales)

Hope this helps,

Jason

[#7]

I have a similar query.  I don't want to reduce the data in my document.  I have a field within my document called 'Active_Dir_User' that also corresponds to an 'Employee_Name' field.  What I need to do is when the document opens, I need the Employee_Name field to be filtered using the Active_Dir_User and OsUser() information...

Can this be achieved without going down the Section Access route??

Many thanks

Tom