Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
Add a line to the load statement:
Groupings:
LOAD *,
wildmatch(ProductName, '*Shebo*') as SheboFlag
INLINE [
ProductName, ProductType
CUSTOM\SheboA112, 1
CUSTOM\SheboB1123, 1
...etc..
Add a line to the load statement:
Groupings:
LOAD *,
wildmatch(ProductName, '*Shebo*') as SheboFlag
INLINE [
ProductName, ProductType
CUSTOM\SheboA112, 1
CUSTOM\SheboB1123, 1
...etc..
=if(WildMatch( SubField(ProductName,'\',2),'Shebo*'),ProductName) as FLAG
PFA.
Thanks, works great!
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?
Sum({<SheboFlag={1}>} Sales)
Hope this helps,
Jason
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